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

Line 494: select null from per_person_types ppt, per_person_type_usages_f ptu

490: and
491: (p_date_start between pap.effective_start_date and pap.effective_end_date);
492:
493: cursor csr_system_person_type is
494: select null from per_person_types ppt, per_person_type_usages_f ptu
495: where ptu.person_id = p_authorising_person_id
496: and p_date_start between ptu.effective_start_date and ptu.effective_end_date
497: and ptu.person_type_id = ppt.person_type_id
498: and (ppt.system_person_type = 'EMP'

Line 688: select null from per_person_types ppt, per_person_type_usages_f ptu

684: and
685: (p_date_start between pap.effective_start_date and pap.effective_end_date);
686:
687: cursor csr_system_person_type is
688: select null from per_person_types ppt, per_person_type_usages_f ptu
689: where ptu.person_id = p_internal_contact_person_id
690: and p_date_start between ptu.effective_start_date and ptu.effective_end_date
691: and ptu.person_type_id = ppt.person_type_id
692: and (ppt.system_person_type = 'EMP'