APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 2494: from JAI_AP_MATCH_INV_TAXES

2490: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
2491: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
2492:
2493: for Misc_loop in ( select *
2494: from JAI_AP_MATCH_INV_TAXES
2495: where invoice_id = p_invoice_id
2496: and parent_invoice_distribution_id = p_invoice_distribution_id
2497: )
2498: loop

Line 2642: from JAI_AP_MATCH_INV_TAXES

2638: IS
2639: cursor c_line_amt
2640: is
2641: select NVL(tax_amount,-1) -- 5763527, Added by kunkumar for Bug#5593895
2642: from JAI_AP_MATCH_INV_TAXES
2643: where invoice_id = p_invoice_id
2644: AND parent_invoice_distribution_id = p_parent_dist_id /*bug 9346307*/
2645: and line_no = p_precedence_value ;
2646:

Line 3019: jai_ap_match_inv_taxes tax_line

3015: tax_line.tax_id tax_id
3016: , tax.tax_type tax_type
3017: , SUM(tax_line.tax_amount) tax_amount
3018: FROM
3019: jai_ap_match_inv_taxes tax_line
3020: , jai_cmn_taxes_all tax
3021: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
3022: AND tax_line.invoice_id = pn_invoice_id
3023: AND tax_line.parent_invoice_line_number = pn_invoice_line_num

Line 3234: -- Get inclusive tax info from jai_ap_match_inv_taxes

3230: );
3231: END IF; --ln_proc_level>=l_dbg_level
3232: END LOOP; -- for standalone_inclu_tax_cur cursor
3233: ELSE
3234: -- Get inclusive tax info from jai_ap_match_inv_taxes
3235: -- and insert debit inclusive taxes into GL interface table.
3236: FOR match_inclu_tax_csr IN match_inclu_tax_cur(ln_invoice_line_num)
3237: LOOP
3238: ln_tax_account_id := get_tax_account_id