APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_RELATIONSHIPS

Line 782: hz_parties hp, fnd_user fu , hz_relationships hzr,

778: hcpp.contact_point_id contact_point_id,
779: hcpp.owner_table_id contact_point_owner_id,
780: hcpp.owner_table_name contact_point_owner_name
781: from
782: hz_parties hp, fnd_user fu , hz_relationships hzr,
783: hz_party_usg_assignments hpua , HZ_CONTACT_POINTS hcpp
784: where hp.party_id = hzr.subject_id
785: and hzr.object_id = l_from_party_id ---:1 -- party of supplier
786: and hzr.relationship_type = 'CONTACT'