APPS.JAI_PO_HOOK_PKG dependencies on RCV_SHIPMENT_LINES

Line 122: SELECT * FROM RCV_SHIPMENT_LINES WHERE shipment_line_id = p_line_id;

118: FROM org_organization_definitions
119: WHERE organization_id = p_inv_orgn_id;
120:
121: CURSOR c_rcpt_line(p_line_id NUMBER) IS
122: SELECT * FROM RCV_SHIPMENT_LINES WHERE shipment_line_id = p_line_id;
123:
124: -- pramasub start
125: CURSOR c_asbn_cur(cp_hdr_intf_id IN NUMBER, cp_cmn_line_id IN NUMBER) IS
126: SELECT lines.cmn_line_id,

Line 1884: from rcv_shipment_lines

1880:
1881: IF p_document_type = 'PO_RECEIPT_ALL' THEN
1882:
1883: FOR rec in (select shipment_header_id,shipment_line_id
1884: from rcv_shipment_lines
1885: WHERE po_line_location_id IN (select line_Location_id
1886: from po_line_locations_all
1887: where po_header_id=p_header_id)
1888: AND (po_release_id = p_release_id or p_release_id is null)

Line 1928: FOR rec in (select shipment_header_id,shipment_line_id from rcv_shipment_lines where po_line_location_id = p_line_id)

1924:
1925:
1926: IF p_document_type = 'PO_RECEIPT' THEN
1927:
1928: FOR rec in (select shipment_header_id,shipment_line_id from rcv_shipment_lines where po_line_location_id = p_line_id)
1929: LOOP
1930: /*bug 9503162*/
1931: ln_net_qty := NULL;
1932: ln_rec_qty := NULL;