APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 817: FROM ap_supplier_contacts

813:
814: -- For loop to fetch all contacts one by one
815: FOR contact_loop_c IN
816: ( SELECT vendor_contact_id, per_party_id, org_party_site_id, org_contact_id, party_site_id
817: FROM ap_supplier_contacts
818: WHERE org_party_site_id = p_from_party_site_id
819: )
820: LOOP
821:

Line 971: UPDATE ap_supplier_contacts

967:
968: END LOOP;
969:
970:
971: UPDATE ap_supplier_contacts
972: SET org_party_site_id = p_to_party_site_id,
973: rel_party_id = l_party_id,
974: relationship_id = l_relationship_id,
975: party_site_id = l_party_site_id