APPS.AHL_OSP_RCV_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 275: FROM PO_REQUISITION_HEADERS_ALL

271:
272: -- Cursor to check whether the given Requisition is approved or not.
273: CURSOR chk_po_req_approved (c_po_req_header_id NUMBER) IS
274: SELECT 'X'
275: FROM PO_REQUISITION_HEADERS_ALL
276: WHERE NVL(authorization_status, 'X') = 'APPROVED'
277: AND requisition_header_id = c_po_req_header_id;
278:
279: -- Cursor to get the PO line quantity details for all the OSP order lines, corresponding to the given return line id.