APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 2270: from JAI_AP_MATCH_INV_TAXES

2266: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
2267: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
2268:
2269: for Misc_loop in ( select *
2270: from JAI_AP_MATCH_INV_TAXES
2271: where invoice_id = p_invoice_id
2272: and parent_invoice_distribution_id = p_invoice_distribution_id
2273: )
2274: loop

Line 2418: from JAI_AP_MATCH_INV_TAXES

2414: IS
2415: cursor c_line_amt
2416: is
2417: select NVL(tax_amount,-1) -- 5763527, Added by kunkumar for Bug#5593895
2418: from JAI_AP_MATCH_INV_TAXES
2419: where invoice_id = p_invoice_id
2420: and line_no = p_precedence_value ;
2421:
2422: cursor c_base_inv_amt

Line 2794: jai_ap_match_inv_taxes tax_line

2790: tax_line.tax_id tax_id
2791: , tax.tax_type tax_type
2792: , SUM(tax_line.tax_amount) tax_amount
2793: FROM
2794: jai_ap_match_inv_taxes tax_line
2795: , jai_cmn_taxes_all tax
2796: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
2797: AND tax_line.invoice_id = pn_invoice_id
2798: AND tax_line.parent_invoice_line_number = pn_invoice_line_num

Line 3009: -- Get inclusive tax info from jai_ap_match_inv_taxes

3005: );
3006: END IF; --ln_proc_level>=l_dbg_level
3007: END LOOP; -- for standalone_inclu_tax_cur cursor
3008: ELSE
3009: -- Get inclusive tax info from jai_ap_match_inv_taxes
3010: -- and insert debit inclusive taxes into GL interface table.
3011: FOR match_inclu_tax_csr IN match_inclu_tax_cur(ln_invoice_line_num)
3012: LOOP
3013: ln_tax_account_id := get_tax_account_id