APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 2194: from JAI_CMN_TAXES_ALL

2190: mod_cr_percentage,
2191: adhoc_flag,
2192: nvl(tax_rate, 0) tax_rate,
2193: tax_type
2194: from JAI_CMN_TAXES_ALL
2195: where tax_id = ln_tax_id;
2196:
2197:
2198: Cursor get_misc_lines (ln_dist_line_number in number,

Line 2543: jai_cmn_taxes_all

2539: CURSOR cur_tax_acc IS
2540: SELECT
2541: tax_account_id
2542: FROM
2543: jai_cmn_taxes_all
2544: WHERE tax_id = pn_tax_id;
2545:
2546: BEGIN
2547: --logging for debug

Line 2795: , jai_cmn_taxes_all tax

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
2799: AND tax_line.tax_id = tax.tax_id

Line 2814: , jai_cmn_taxes_all tax

2810: , tax.tax_type tax_type
2811: , SUM(tax_line.tax_amt) tax_amount
2812: FROM
2813: jai_cmn_document_taxes tax_line
2814: , jai_cmn_taxes_all tax
2815: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
2816: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE
2817: AND tax_line.source_doc_id = pn_invoice_id
2818: AND tax_line.source_doc_parent_line_no = pn_invoice_line_num