$Applaud$

Query to get CEO Name - Orapoint

  • Home
  • Query to get CEO Name

SELECT person_name
FROM (SELECT pei.ROWID row_id,
pei.person_id person_id,
ppf.full_name person_name,
rls.role_name role_name
FROM apps.per_people_extra_info pei,
apps.per_all_people_f ppf,
apps.fnd_user usr,
apps.pqh_roles rls
WHERE information_type = ‘PQH_ROLE_USERS’
AND pei.person_id = ppf.person_id
AND usr.employee_id = ppf.person_id
AND rls.enable_flag = ‘Y’
AND pei.pei_information5 = ‘Y’
AND rls.role_id = TO_NUMBER (pei.pei_information3))
WHERE role_name = ‘CEO’ AND ROWNUM < 2;