DBA Data[Home] [Help]

APPS.AML_LEAD_DEDUPE_PVT dependencies on HZ_RELATIONSHIPS

Line 208: hz_relationships hzr

204: CURSOR c_contact_cp IS
205: SELECT hzpc.party_id
206: FROM hz_parties hzpc,
207: hz_parties hzpr,
208: hz_relationships hzr
209: WHERE hzpc.party_id = p_dup_rec.contact_id
210: AND hzpc.party_id = hzr.subject_id
211: AND hzr.party_id = hzpr.party_id
212: AND hzr.relationship_code IN ('CONTACT_OF', 'EMPLOYEE_OF')