APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_SUPPLIER_SITES

Line 1072: FROM ap_supplier_sites

1068: g_action := 'check for vendor site';
1069: BEGIN
1070: SELECT vendor_site_id
1071: INTO l_vendor_site_id
1072: FROM ap_supplier_sites
1073: WHERE vendor_id = p_vinfo_rec.vendor_id
1074: AND upper(vendor_site_code) = UPPER(p_site_code);
1075:
1076: l_vendor_found := true;

Line 1256: from ap_supplier_sites

1252:
1253: /* Adding following block to Fix Bug: 5258874 to update supplier site address locations*/
1254: BEGIN
1255: select location_id into p_location_rec.location_id
1256: from ap_supplier_sites
1257: where vendor_id = p_vinfo_rec.vendor_id and vendor_site_id = l_vendor_site_id;
1258: IF (l_Debug_Level <= 1) THEN
1259: itg_debug_pub.Add('location_id - '|| p_location_rec.location_id,1);
1260: END IF;

Line 1428: FROM ap_supplier_sites

1424: g_action := 'Vendor-contact information sync';
1425:
1426: SELECT vendor_site_id
1427: INTO l_vsite_id
1428: FROM ap_supplier_sites
1429: WHERE UPPER(vendor_site_code) = UPPER(p_site_code)
1430: AND vendor_id = p_vinfo_rec.vendor_id;
1431:
1432: IF (l_Debug_Level <= 1) THEN