APPS.JAI_PO_HOOK_PKG dependencies on RCV_SHIPMENT_LINES

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

78: FROM org_organization_definitions
79: WHERE organization_id = p_inv_orgn_id;
80:
81: CURSOR c_rcpt_line(p_line_id NUMBER) IS
82: SELECT * FROM RCV_SHIPMENT_LINES WHERE shipment_line_id = p_line_id;
83:
84: -- pramasub start
85: CURSOR c_asbn_cur(cp_hdr_intf_id IN NUMBER, cp_cmn_line_id IN NUMBER) IS
86: SELECT lines.cmn_line_id,

Line 1723: from rcv_shipment_lines

1719:
1720: IF p_document_type = 'PO_RECEIPT_ALL' THEN
1721:
1722: FOR rec in (select shipment_header_id,shipment_line_id
1723: from rcv_shipment_lines
1724: WHERE po_line_location_id IN (select line_Location_id
1725: from po_line_locations_all
1726: where po_header_id=p_header_id)
1727: AND (po_release_id = p_release_id or p_release_id is null)

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

1749:
1750:
1751: IF p_document_type = 'PO_RECEIPT' THEN
1752:
1753: FOR rec in (select shipment_header_id,shipment_line_id from rcv_shipment_lines where po_line_location_id = p_line_id)
1754: LOOP
1755: ln_tax_amt := ln_tax_amt + gettax('RECEIPTS',rec.shipment_header_id,rec.shipment_line_id);
1756: END LOOP;
1757: RETURN (ln_tax_amt);