APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_SUPPLIER_SITES

Line 1070: FROM ap_supplier_sites

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

Line 1254: from ap_supplier_sites

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

Line 1426: FROM ap_supplier_sites

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