APPS.HR_SECURITY_INTERNAL dependencies on PER_CONTACT_RELATIONSHIPS

Line 4052: from per_contact_relationships pcr

4048: -- The contacts must not have any assignments because
4049: -- assignments are evaluated at an earlier point in the process.
4050: cursor csr_related_contacts(p_person_id in number) is
4051: select pcr.contact_person_id
4052: from per_contact_relationships pcr
4053: where pcr.person_id = p_person_id
4054: and p_effective_date between pcr.date_start
4055: and nvl(pcr.date_end, hr_api.g_eot)
4056: and not exists

Line 4075: from per_contact_relationships pcr

4071: and papf.npw_number is null
4072: and papf.applicant_number is null
4073: and not exists
4074: (select null
4075: from per_contact_relationships pcr
4076: where pcr.contact_person_id = papf.person_id)
4077: and not exists
4078: (select null
4079: from per_person_type_usages_f ptuf,

Line 4203: from per_contact_relationships pcr

4199: from per_all_assignments_f paaf
4200: where paaf.person_id = ptuf.person_id)
4201: and not exists
4202: (select null
4203: from per_contact_relationships pcr
4204: where pcr.contact_person_id = ptuf.person_id);
4205: --
4206: begin
4207: --