APPS.JAI_PO_HOOK_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 1235: FROM JAI_AP_MATCH_INV_TAXES

1231:
1232: -- pramasub start
1233: CURSOR c_conv_rate_inv(cp_header_id IN NUMBER, cp_line_id IN NUMBER) IS
1234: SELECT exchange_rate, currency_code
1235: FROM JAI_AP_MATCH_INV_TAXES
1236: WHERE invoice_id = cp_header_id
1237: And parent_invoice_distribution_id = cp_line_id;
1238: -- pramasub end
1239:

Line 1511: FROM JAI_AP_MATCH_INV_TAXES

1507: INTO ln_tax_amt;
1508: CLOSE c_inv_amt;
1509: Else
1510: For r_ap_in_dist in (SELECT currency_code, SUM(tax_amount) tax_amount
1511: FROM JAI_AP_MATCH_INV_TAXES
1512: where invoice_id = p_header_id
1513: And parent_invoice_distribution_id = p_line_id
1514: GROUP BY currency_code)
1515: Loop

Line 2399: jai_ap_match_inv_taxes jamit

2395: SELECT
2396: jamit.currency_code
2397: , SUM(jamit.tax_amount) tax_amount
2398: FROM
2399: jai_ap_match_inv_taxes jamit
2400: , jai_cmn_taxes_all jcta
2401: WHERE jamit.invoice_id = pn_header_id
2402: AND (jamit.parent_invoice_distribution_id = pn_line_id OR pn_line_id IS NULL)
2403: AND jcta.tax_id = jamit.tax_id

Line 2416: FROM jai_ap_match_inv_taxes

2412: IS
2413: SELECT
2414: exchange_rate
2415: , currency_code
2416: FROM jai_ap_match_inv_taxes
2417: WHERE invoice_id = pn_csr_header_id
2418: AND parent_invoice_distribution_id = pn_csr_line_id;
2419:
2420: -- Get the shipments tax amount