APPS.HR_AUTH_BRIDGE dependencies on PER_CONTACT_RELATIONSHIPS

Line 254: FROM per_contact_relationships pcr

250: --
251:
252: CURSOR c_contacts IS
253: SELECT HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) contact_type
254: FROM per_contact_relationships pcr
255: WHERE pcr.person_id = p_person_id
256: AND pcr.contact_person_id = p_contact_person_id
257: AND p_effective_date BETWEEN NVL(pcr.date_start,p_effective_date) AND NVL(pcr.date_end,p_effective_date)
258: ORDER BY DECODE(pcr.personal_flag,'Y',1),pcr.contact_type;