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.HR_PDT_BUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 676: from per_person_type_usages_f ptu,

672: and per.business_group_id = p_to_business_group_id;
673: --
674: cursor csr_check_per_type(p_person_id number) is
675: select ptu.person_type_id
676: from per_person_type_usages_f ptu,
677: per_person_types ppt
678: where ptu.person_id = p_person_id
679: and ptu.person_type_id = ppt.person_type_id
680: and ppt.system_person_type in ('EMP','CWK','APL')

Line 685: from per_person_type_usages_f ptu,

681: and ptu.effective_end_date >= p_start_date;
682: --
683: cursor csr_check_per_type2(p_person_id number) is
684: select ptu.person_type_id
685: from per_person_type_usages_f ptu,
686: per_person_types ppt
687: where ptu.person_id = p_person_id
688: and ptu.person_type_id = ppt.person_type_id
689: and ppt.system_person_type in ('EMP','CWK','APL')

Line 692: from per_person_type_usages_f ptu1,

688: and ptu.person_type_id = ppt.person_type_id
689: and ppt.system_person_type in ('EMP','CWK','APL')
690: and ptu.effective_start_date > p_start_date
691: and not exists (select 1
692: from per_person_type_usages_f ptu1,
693: per_person_types ppt1
694: where ptu.person_type_usage_id = ptu1.person_type_usage_id
695: and ptu1.person_type_id = ppt1.person_type_id
696: and ppt1.system_person_type in ('EMP','CWK','APL')