APPS.IRC_PARTY_PERSON_UTL dependencies on PER_PERSON_TYPE_USAGES_F

Line 154: from per_person_type_usages_f ptu

150: and trunc(sysdate) between effective_start_date and effective_end_date;
151:
152: cursor get_ptu_entry(p_person_id number) is
153: select 1
154: from per_person_type_usages_f ptu
155: , per_person_types ppt
156: where ptu.person_id=p_person_id
157: and ptu.person_type_id=ppt.person_type_id
158: and ppt.system_person_type='IRC_REG_USER';