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.PER_FR_WORK_ACC_UPG_PKG dependencies on PER_ALL_PEOPLE_F

Line 21: , per_all_people_f per1

17: pei.PEI_INFORMATION8,
18: pei.PEI_INFORMATION9,
19: pei.PERSON_EXTRA_INFO_ID
20: FROM per_people_extra_info pei
21: , per_all_people_f per1
22: WHERE pei.PEI_INFORMATION_CATEGORY = 'FR_WORK_ACCI'
23: AND pei.person_id = per1.person_id
24: AND per1.business_group_id = p_business_group_id
25: AND per1.effective_start_date = (select min(per2.effective_start_date)

Line 26: from per_all_people_f per2

22: WHERE pei.PEI_INFORMATION_CATEGORY = 'FR_WORK_ACCI'
23: AND pei.person_id = per1.person_id
24: AND per1.business_group_id = p_business_group_id
25: AND per1.effective_start_date = (select min(per2.effective_start_date)
26: from per_all_people_f per2
27: where per2.person_id = per1.person_id
28: and per2.business_group_id = p_business_group_id)
29: AND pei.PEI_INFORMATION30 IS NULL
30: order by per1.full_name;