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)