APPS.HR_SECURITY_INTERNAL dependencies on PER_CONTACT_RELATIONSHIPS

Line 4012: from per_contact_relationships pcr

4008: -- The contacts must not have any assignments because
4009: -- assignments are evaluated at an earlier point in the process.
4010: cursor csr_related_contacts(p_person_id in number) is
4011: select pcr.contact_person_id
4012: from per_contact_relationships pcr
4013: where pcr.person_id = p_person_id
4014: and p_effective_date between pcr.date_start
4015: and nvl(pcr.date_end, hr_api.g_eot)
4016: and not exists

Line 4035: from per_contact_relationships pcr

4031: and papf.npw_number is null
4032: and papf.applicant_number is null
4033: and not exists
4034: (select null
4035: from per_contact_relationships pcr
4036: where pcr.contact_person_id = papf.person_id)
4037: and not exists
4038: (select null
4039: from per_person_type_usages_f ptuf,

Line 4163: from per_contact_relationships pcr

4159: from per_all_assignments_f paaf
4160: where paaf.person_id = ptuf.person_id)
4161: and not exists
4162: (select null
4163: from per_contact_relationships pcr
4164: where pcr.contact_person_id = ptuf.person_id);
4165: --
4166: begin
4167: --