APPS.JAI_PO_HOOK_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1203: FROM JAI_RCV_LINE_TAXES

1199: ORDER BY rtl.currency;
1200: /* Get the receipt tax amount for each shipment line currency code wise*/
1201: CURSOR c_rcpt_tax_amt IS
1202: SELECT shipment_line_id, currency, SUM(tax_amount) tax_amount
1203: FROM JAI_RCV_LINE_TAXES
1204: WHERE shipment_header_id = p_header_id
1205: AND (shipment_line_id = p_line_id OR p_line_id IS NULL)
1206: GROUP BY shipment_line_id, currency;
1207: /* Get the conversion rate for the currency code for the requisition line */

Line 2349: jai_rcv_line_taxes jrlt

2345: jrlt.shipment_line_id
2346: , jrlt.currency
2347: , SUM(jrlt.tax_amount) tax_amount
2348: FROM
2349: jai_rcv_line_taxes jrlt
2350: , jai_cmn_taxes_all jcta
2351: WHERE jrlt.shipment_header_id = pn_header_id
2352: AND (jrlt.shipment_line_id = pn_line_id OR pn_line_id IS NULL)
2353: AND jcta.tax_id = jrlt.tax_id