DBA Data[Home] [Help]

APPS.CSP_RECEIVE_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 53: FROM rcv_shipment_headers rsh

49:
50: BEGIN
51: SELECT 1
52: INTO l_receipt_exists
53: FROM rcv_shipment_headers rsh
54: WHERE receipt_num = x_receipt_num
55: AND ship_to_org_id = p_organization_id;
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN

Line 336: from RCV_SHIPMENT_HEADERS

332: -- bug # 10401140
333: l_rcpt_num number;
334: cursor get_rcpt_num is
335: select RECEIPT_NUM
336: from RCV_SHIPMENT_HEADERS
337: where shipment_header_id = p_receive_hdr_rec.receipt_header_id;
338:
339: BEGIN
340: SAVEPOINT receive_shipments_pvt;