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_PDS_BUS dependencies on PER_PERSON_TYPES

Line 141: from per_person_type_usages_f ptu, per_person_types ppt

137: where per.person_id = p_person_id;
138: -- ER FPT
139: cursor not_allowed_ppt is
140: select ptu.effective_start_date
141: from per_person_type_usages_f ptu, per_person_types ppt
142: where ptu.person_id = p_person_id
143: and ptu.person_type_id = ppt.person_type_id
144: and ptu.effective_start_date > p_actual_termination_date
145: and ppt.system_person_type in ('EMP','CWK');

Line 1392: per_person_types pt

1388: --
1389: cursor csr_valid_pers_date is
1390: select null
1391: from per_all_people_f p,
1392: per_person_types pt
1393: where p.person_id = p_person_id
1394: and p.effective_start_date = p_date_start
1395: and pt.person_type_id = p.person_type_id
1396: and pt.system_person_type in ('EMP', 'EMP_APL');