DBA Data[Home] [Help]

APPS.BEN_DT_TRGR_HANDLE dependencies on PER_CONTACT_RELATIONSHIPS

Line 745: from per_contact_relationships pcr

741: select ptu.person_id, ppt.system_person_type
742: from per_person_type_usages_f ptu,
743: per_person_types ppt
744: where ptu.person_id in (select pcr.contact_person_id
745: from per_contact_relationships pcr
746: where pcr.person_id = p_person_id
747: )
748: and trunc(p_pds_old_atd+1) between trunc(ptu.effective_start_date)
749: and trunc(ptu.effective_end_date)