APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on PO_VENDOR_SITES_ALL
Line 2949: FROM po_vendor_sites_all
2945: P_X_Error_Status);
2946: ELSIF P_Vendor_Site_Id IS NOT NULL THEN
2947: BEGIN
2948: SELECT vendor_site_id INTO l_vendor_site_id 2949: FROM po_vendor_sites_all 2950: WHERE vendor_site_id = P_Vendor_Site_Id
2951: AND vendor_id = P_Vendor_Id
2952: AND purchasing_site_flag = 'Y'
2953: AND NVL(inactive_date, sysdate+1) > sysdate;