APPS.RCV_FTE_CALL_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 93: rcv_shipment_headers rsh,

89: IF(p_action IN ('RECEIPT', 'SHIP', 'MATCH')) THEN
90: SELECT count(rsl.shipment_line_id)
91: INTO l_valid_lines
92: FROM rcv_shipment_lines rsl,
93: rcv_shipment_headers rsh,
94: po_headers_all poh,
95: po_lines_all pol,
96: po_line_types_b plb
97: WHERE

Line 121: FROM rcv_shipment_headers

117: -- Then this should be a RECEIPT_ADD
118: -- Rather than a 'RECEIPT'
119: SELECT asn_type
120: INTO l_is_asn
121: FROM rcv_shipment_headers
122: WHERE shipment_header_id = p_shipment_header_id;
123:
124: IF (l_is_asn IS NOT NULL)
125: THEN