APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_SUPPLIER_CONTACTS

Line 1447: from HZ_PARTIES h, ap_supplier_contacts a

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