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.IRC_CANDIDATE_TEST dependencies on PER_PERSON_TYPES

Line 23: , per_person_types ppt

19: l_party_id number;
20: --
21: cursor c_person is
22: select 1 from per_person_type_usages_f ptu
23: , per_person_types ppt
24: where ptu.person_id=p_person_id
25: and ppt.person_type_id=ptu.person_type_id
26: and ppt.system_person_type='IRC_REG_USER'
27: and sysdate between ptu.effective_start_date and ptu.effective_end_date;

Line 31: , per_person_types ppt

27: and sysdate between ptu.effective_start_date and ptu.effective_end_date;
28: --
29: cursor c_person_party is
30: select 1 from per_person_type_usages_f ptu
31: , per_person_types ppt
32: ,per_all_people_f per
33: where ptu.person_id=per.person_id
34: and ppt.person_type_id=ptu.person_type_id
35: and ppt.system_person_type='IRC_REG_USER'