APPS.AHL_OSP_RCV_PVT dependencies on PO_REQUISITION_HEADERS_V
Line 743: FROM PO_REQUISITION_HEADERS_V
739:
740: -- Cursor to check whether the given Requisition is approved or not.
741: CURSOR chk_po_req_approved (c_po_req_header_id NUMBER) IS
742: SELECT 'X' 743: FROM PO_REQUISITION_HEADERS_V 744: WHERE NVL(authorization_status, 'X') = 'APPROVED'
745: AND requisition_header_id = c_po_req_header_id;
746:
747: -- Cursor to get the PO line quantity details for all the OSP order lines, corresponding to the given return line id.