DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_VENDORS_VIEW

Line 1102: SELECT 'x' FROM PO_VENDORS_VIEW

1098: WHERE OSP_ORDER_ID = p_osp_order_id
1099: FOR UPDATE OF PO_BATCH_ID, PO_REQUEST_ID; -- Lock Row
1100:
1101: CURSOR l_validate_supplier_csr(p_supplier_id IN NUMBER) IS
1102: SELECT 'x' FROM PO_VENDORS_VIEW
1103: WHERE VENDOR_ID = p_supplier_id
1104: AND ENABLED_FLAG = G_YES_FLAG
1105: AND NVL(VENDOR_START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
1106: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;