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

Line 124: from per_all_people_f per

120: -- Cursor to select the person's sex which is required for CPDF Edits
121:
122: cursor c_person_sex is
123: select per.sex
124: from per_all_people_f per
125: where per.person_id = P_pa_request_rec.person_id
126: and g_effective_date
127: between per.effective_start_date
128: and per.effective_end_date;

Line 169: per_all_people_f ppf

165:
166: cursor c_person_type is
167: select ppt.system_person_type
168: from per_person_types ppt,
169: per_all_people_f ppf
170: where ppf.person_id = p_pa_request_rec.person_id
171: and ppt.person_type_id = ppf.person_type_id
172: and p_pa_request_rec.effective_date
173: between ppf.effective_start_date

Line 805: per_all_people_f ppf

801:
802: cursor c_person_type is
803: select ppt.system_person_type
804: from per_person_types ppt,
805: per_all_people_f ppf
806: where ppf.person_id = p_pa_request_rec.person_id
807: and ppt.person_type_id = ppf.person_type_id
808: and g_effective_date
809: between ppf.effective_start_date

Line 1661: per_all_people_f ppf

1657:
1658: cursor c_person_type is
1659: select ppt.system_person_type
1660: from per_person_types ppt,
1661: per_all_people_f ppf
1662: where ppf.person_id = p_pa_request_rec.person_id
1663: and ppt.person_type_id = ppf.person_type_id
1664: and g_effective_date
1665: between ppf.effective_start_date