APPS.POR_VIEW_REQS_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 653: from RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL

649: function get_shipment_number(req_line_id NUMBER) RETURN VARCHAR2 is
650: p_values dbms_sql.VARCHAR2_TABLE;
651: begin
652: select RSH.SHIPMENT_NUM BULK COLLECT INTO p_values
653: from RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL
654: WHERE RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
655: AND RSL.REQUISITION_LINE_ID = req_line_id;
656:
657: if (p_values IS NULL or p_values.COUNT < 1) then