DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 3038: jai_cmn_document_taxes tax_line

3034: tax_line.tax_id tax_id
3035: , tax.tax_type tax_type
3036: , SUM(tax_line.tax_amt) tax_amount
3037: FROM
3038: jai_cmn_document_taxes tax_line
3039: , jai_cmn_taxes_all tax
3040: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
3041: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE
3042: AND tax_line.source_doc_id = pn_invoice_id

Line 3195: -- Get inclusive tax info from jai_cmn_document_taxes

3191: IF ln_invoice_post_num = 1
3192: THEN
3193: IF lv_match_type = jai_constants.G_AP_STANDALONE_INVOICE
3194: THEN
3195: -- Get inclusive tax info from jai_cmn_document_taxes
3196: -- and insert debit inclusive taxes into GL interface table.
3197: FOR standalone_inclu_tax_csr IN standalone_inclu_tax_cur(ln_invoice_line_num)
3198: LOOP
3199: ln_tax_account_id := get_tax_account_id