DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 2813: jai_cmn_document_taxes tax_line

2809: tax_line.tax_id tax_id
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

Line 2970: -- Get inclusive tax info from jai_cmn_document_taxes

2966: IF ln_invoice_post_num = 1
2967: THEN
2968: IF lv_match_type = jai_constants.G_AP_STANDALONE_INVOICE
2969: THEN
2970: -- Get inclusive tax info from jai_cmn_document_taxes
2971: -- and insert debit inclusive taxes into GL interface table.
2972: FOR standalone_inclu_tax_csr IN standalone_inclu_tax_cur(ln_invoice_line_num)
2973: LOOP
2974: ln_tax_account_id := get_tax_account_id