APPS.JAI_PO_HOOK_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1074: FROM JAI_RCV_LINE_TAXES

1070: ORDER BY rtl.currency;
1071: /* Get the receipt tax amount for each shipment line currency code wise*/
1072: CURSOR c_rcpt_tax_amt IS
1073: SELECT shipment_line_id, currency, SUM(tax_amount) tax_amount
1074: FROM JAI_RCV_LINE_TAXES
1075: WHERE shipment_header_id = p_header_id
1076: AND (shipment_line_id = p_line_id OR p_line_id IS NULL)
1077: GROUP BY shipment_line_id, currency;
1078: /* Get the conversion rate for the currency code for the requisition line */

Line 2147: jai_rcv_line_taxes jrlt

2143: jrlt.shipment_line_id
2144: , jrlt.currency
2145: , SUM(jrlt.tax_amount) tax_amount
2146: FROM
2147: jai_rcv_line_taxes jrlt
2148: , jai_cmn_taxes_all jcta
2149: WHERE jrlt.shipment_header_id = pn_header_id
2150: AND (jrlt.shipment_line_id = pn_line_id OR pn_line_id IS NULL)
2151: AND jcta.tax_id = jrlt.tax_id