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
4057: (select null
4058: from per_all_assignments_f paaf
4059: where paaf.person_id = pcr.contact_person_id