DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on PO_VENDORS_VIEW

Line 1363: SELECT 'x' FROM PO_VENDORS_VIEW

1359: -- AND STATUS_CODE = G_OSP_SUBMITTED_STATUS
1360: FOR UPDATE OF PO_BATCH_ID, PO_REQUEST_ID; -- Lock Row
1361:
1362: CURSOR l_validate_supplier_csr(p_supplier_id IN NUMBER) IS
1363: SELECT 'x' FROM PO_VENDORS_VIEW
1364: WHERE VENDOR_ID = p_supplier_id
1365: AND ENABLED_FLAG = G_YES_FLAG
1366: AND NVL(VENDOR_START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
1367: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;