DBA Data[Home] [Help]

APPS.HR_SECURITY_INTERNAL dependencies on HR_API

Line 4055: and nvl(pcr.date_end, hr_api.g_eot)

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