APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_CONTACT_POINTS

Line 783: hz_party_usg_assignments hpua , HZ_CONTACT_POINTS hcpp

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'
787: and hzr.relationship_code = 'CONTACT_OF'

Line 957: from hz_contact_points

953: l_telex_rec.telex_number,
954: l_web_rec.web_type,
955: l_web_rec.url,
956: l_contact_point_rec.application_id
957: from hz_contact_points
958: where contact_point_id = contact_point_loop_c.contact_point_id;
959:
960: l_contact_point_rec.owner_table_id := l_party_id;
961: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';