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.HR_PAY_INTERFACE_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 1272: FROM per_people_extra_info pei

1268: pei.pei_information4,
1269: pei.pei_information5,
1270: pei.pei_information6,
1271: pei.pei_information7
1272: FROM per_people_extra_info pei
1273: WHERE pei.person_id = cp_person_id
1274: AND pei.information_type = 'US_ETHNIC_ORIGIN'
1275: AND pei.last_update_date = (SELECT max(pei2.last_update_date)
1276: FROM per_people_extra_info pei2

Line 1276: FROM per_people_extra_info pei2

1272: FROM per_people_extra_info pei
1273: WHERE pei.person_id = cp_person_id
1274: AND pei.information_type = 'US_ETHNIC_ORIGIN'
1275: AND pei.last_update_date = (SELECT max(pei2.last_update_date)
1276: FROM per_people_extra_info pei2
1277: WHERE pei2.person_id = cp_person_id
1278: AND pei2.information_type = 'US_ETHNIC_ORIGIN'
1279: );
1280: l_ethnic_origin NUMBER;