APPS.AHL_OSP_RCV_PVT dependencies on PO_REQUISITION_HEADERS_V

Line 973: FROM PO_REQUISITION_HEADERS_V

969:
970: -- Cursor to check whether the given Requisition is approved or not.
971: CURSOR chk_po_req_approved (c_po_req_header_id NUMBER) IS
972: SELECT 'X'
973: FROM PO_REQUISITION_HEADERS_V
974: WHERE NVL(authorization_status, 'X') = 'APPROVED'
975: AND requisition_header_id = c_po_req_header_id;
976:
977: -- Cursor to get the PO line quantity details for all the OSP order lines, corresponding to the given return line id.