APPS.JAI_PO_HOOK_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 1106: FROM JAI_AP_MATCH_INV_TAXES

1102:
1103: -- pramasub start
1104: CURSOR c_conv_rate_inv(cp_header_id IN NUMBER, cp_line_id IN NUMBER) IS
1105: SELECT exchange_rate, currency_code
1106: FROM JAI_AP_MATCH_INV_TAXES
1107: WHERE invoice_id = cp_header_id
1108: And parent_invoice_distribution_id = cp_line_id;
1109: -- pramasub end
1110:

Line 1382: FROM JAI_AP_MATCH_INV_TAXES

1378: INTO ln_tax_amt;
1379: CLOSE c_inv_amt;
1380: Else
1381: For r_ap_in_dist in (SELECT currency_code, SUM(tax_amount) tax_amount
1382: FROM JAI_AP_MATCH_INV_TAXES
1383: where invoice_id = p_header_id
1384: And parent_invoice_distribution_id = p_line_id
1385: GROUP BY currency_code)
1386: Loop

Line 2197: jai_ap_match_inv_taxes jamit

2193: SELECT
2194: jamit.currency_code
2195: , SUM(jamit.tax_amount) tax_amount
2196: FROM
2197: jai_ap_match_inv_taxes jamit
2198: , jai_cmn_taxes_all jcta
2199: WHERE jamit.invoice_id = pn_header_id
2200: AND (jamit.parent_invoice_distribution_id = pn_line_id OR pn_line_id IS NULL)
2201: AND jcta.tax_id = jamit.tax_id

Line 2214: FROM jai_ap_match_inv_taxes

2210: IS
2211: SELECT
2212: exchange_rate
2213: , currency_code
2214: FROM jai_ap_match_inv_taxes
2215: WHERE invoice_id = pn_csr_header_id
2216: AND parent_invoice_distribution_id = pn_csr_line_id;
2217:
2218: -- Get the shipments tax amount