191: WHERE shipment_header_id = l_doc_id;
192: ELSIF l_doc_type in ('RECV') THEN
193: SELECT recv_no
194: INTO l_doc_no 195: FROM po_recv_hdr 196: WHERE recv_id = l_doc_id;
197: ELSIF l_doc_type in ('PROD') THEN
198: SELECT batch_no
199: INTO l_doc_no