DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 1531: , jai_cmn_taxes_all jcta

1527:
1528: CURSOR get_tax_type_cur IS
1529: SELECT jcta.tax_type
1530: FROM jai_cmn_document_taxes jcdt
1531: , jai_cmn_taxes_all jcta
1532: , jai_ap_invoice_lines jail
1533: , jai_rgm_registrations jrr
1534: , jai_rgm_definitions jrd
1535: WHERE jcdt.source_doc_id = pr_rec.invoice_id

Line 1549: , jai_cmn_taxes_all jcta

1545:
1546: CURSOR get_matched_tax_cur IS
1547: SELECT jamt.tax_amount,jcta.tax_type
1548: FROM jai_ap_match_inv_taxes jamt
1549: , jai_cmn_taxes_all jcta
1550: , jai_rgm_registrations jrr
1551: , jai_rgm_definitions jrd
1552: WHERE jamt.invoice_id = pr_rec.invoice_id
1553: AND jamt.invoice_line_number = pr_rec.invoice_line_number