APPS.POR_VIEW_REQS_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 575: from RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL

571: function get_shipment_number(req_line_id NUMBER) RETURN VARCHAR2 is
572: p_values dbms_sql.VARCHAR2_TABLE;
573: begin
574: select RSH.SHIPMENT_NUM BULK COLLECT INTO p_values
575: from RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL
576: WHERE RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
577: AND RSL.REQUISITION_LINE_ID = req_line_id;
578:
579: if (p_values IS NULL or p_values.COUNT < 1) then