DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on PO_VENDORS_VIEW

Line 1355: SELECT 'x' FROM PO_VENDORS_VIEW

1351: -- AND STATUS_CODE = G_OSP_SUBMITTED_STATUS
1352: FOR UPDATE OF PO_BATCH_ID, PO_REQUEST_ID; -- Lock Row
1353:
1354: CURSOR l_validate_supplier_csr(p_supplier_id IN NUMBER) IS
1355: SELECT 'x' FROM PO_VENDORS_VIEW
1356: WHERE VENDOR_ID = p_supplier_id
1357: AND ENABLED_FLAG = G_YES_FLAG
1358: AND NVL(VENDOR_START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
1359: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;