APPS.IRC_CANDIDATE_TEST dependencies on PER_ALL_PEOPLE_F

Line 16: from per_all_people_f per

12: (p_person_id in number)
13: return boolean is
14: cursor c_party is
15: select per.party_id
16: from per_all_people_f per
17: where per.person_id=p_person_id
18: and sysdate between per.effective_start_date and per.effective_end_date;
19: l_party_id number;
20: --

Line 32: ,per_all_people_f per

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'
36: and sysdate between ptu.effective_start_date and ptu.effective_end_date