DBA Data[Home] [Help]

APPS.BEN_DT_TRGR_HANDLE dependencies on PER_CONTACT_RELATIONSHIPS

Line 821: from per_contact_relationships pcr

817: select ptu.person_id, ppt.system_person_type
818: from per_person_type_usages_f ptu,
819: per_person_types ppt
820: where ptu.person_id in (select pcr.contact_person_id
821: from per_contact_relationships pcr
822: where pcr.person_id = p_person_id
823: )
824: and trunc(p_pds_old_atd+1) between trunc(ptu.effective_start_date)
825: and trunc(ptu.effective_end_date)