eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_EXEMP_PURGE dependencies on PER_ALL_PEOPLE_F

Line 17: SELECT full_name, employee_number, national_identifier, person_id, effective_start_date FROM PER_ALL_PEOPLE_F WHERE EFFECTIVE_START_DATE <= l_cutoff_dt

13: l_business_group number;
14:
15: CURSOR fetch_ex_emps
16: IS
17: SELECT full_name, employee_number, national_identifier, person_id, effective_start_date FROM PER_ALL_PEOPLE_F WHERE EFFECTIVE_START_DATE <= l_cutoff_dt
18: AND BUSINESS_GROUP_ID = l_business_group
19: AND PERSON_TYPE_ID IN (SELECT PERSON_TYPE_ID FROM PER_PERSON_TYPES
20: WHERE BUSINESS_GROUP_ID = l_business_group AND
21: SYSTEM_PERSON_TYPE in ('EX_EMP', 'EX_CWK'))