APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_SUPPLIER_CONTACTS

Line 1445: from HZ_PARTIES h, ap_supplier_contacts a

1441: g_action := 'Vendor-contact information sync';
1442:
1443: select h.party_id, h.object_version_number
1444: into l_party_id,l_obj_ver_num
1445: from HZ_PARTIES h, ap_supplier_contacts a
1446: where a.per_party_id = h.party_id
1447: and a.vendor_site_id = l_vsite_id
1448: AND NVL(upper(person_first_name), '1') = NVL(upper(p_first_name), '1')
1449: AND NVL(upper(person_middle_name), '1') = NVL(upper(p_middle_name), '1')