DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 1533: , jai_rgm_registrations jrr

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
1536: AND jail.invoice_id = pr_rec.invoice_id
1537: AND jail.invoice_line_number = jcdt.source_doc_line_id

Line 1550: , jai_rgm_registrations jrr

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
1554: AND jamt.tax_id=jcta.tax_id