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_ELT_TO_BEN_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 25: FROM per_all_people_f a,hr_organization_information hoi

21:
22: -- Cursor to fetch distinct person records.
23: CURSOR c_per_records IS
24: SELECT distinct a.person_id person_id
25: FROM per_all_people_f a,hr_organization_information hoi
26: WHERE a.business_group_id = hoi.organization_id
27: AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
28:
29: -- Cursor to find total number of distinct person records

Line 32: FROM per_all_people_f a,hr_organization_information hoi

28:
29: -- Cursor to find total number of distinct person records
30: CURSOR c_tot_per_records IS
31: SELECT COUNT(distinct a.person_id) person_count
32: FROM per_all_people_f a,hr_organization_information hoi
33: WHERE a.business_group_id = hoi.organization_id
34: AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
35:
36: CURSOR c_completion_status(c_session_id NUMBER) IS