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_GENERAL dependencies on PER_ALL_PEOPLE_F

Line 365: from per_all_people_f

361: Cursor c_get_ssn is
362: select national_identifier,
363: --Bug # 9329643
364: employee_number
365: from per_all_people_f
366: where person_id = p_person_id
367: and trunc(p_effective_date) between effective_start_date and effective_end_date;
368: Begin
369: for ler_rec in get_ler_id loop

Line 844: from per_all_people_f

840: Cursor c_get_ssn is
841: --Bug # 9329643
842: select national_identifier,
843: employee_number
844: from per_all_people_f
845: where person_id = p_person_id
846: and trunc(p_effective_date) between effective_start_date and effective_end_date;
847:
848: BEGIN

Line 1211: from per_all_people_f

1207: Cursor c_get_ssn is
1208: --Bug # 9329643 added employee number
1209: select national_identifier,
1210: employee_number
1211: from per_all_people_f
1212: where person_id = p_person_id
1213: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1214:
1215: BEGIN