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 361: from per_all_people_f

357: and trunc(p_effective_date) between effective_start_date and effective_end_date;
358:
359: Cursor c_get_ssn is
360: select national_identifier
361: from per_all_people_f
362: where person_id = p_person_id
363: and trunc(p_effective_date) between effective_start_date and effective_end_date;
364: Begin
365: for ler_rec in get_ler_id loop

Line 828: from per_all_people_f

824: and pgm_id = l_pgm_id;
825:
826: Cursor c_get_ssn is
827: select national_identifier
828: from per_all_people_f
829: where person_id = p_person_id
830: and trunc(p_effective_date) between effective_start_date and effective_end_date;
831:
832: BEGIN

Line 1183: from per_all_people_f

1179: and pgm_id = l_pgm_id;
1180:
1181: Cursor c_get_ssn is
1182: select national_identifier
1183: from per_all_people_f
1184: where person_id = p_person_id
1185: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1186:
1187: BEGIN