DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 1534: , jai_rgm_definitions jrd

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
1538: AND jail.invoice_line_number = pr_rec.invoice_line_number

Line 1551: , jai_rgm_definitions jrd

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
1555: AND jamt.recoverable_flag = 'Y'

Line 1585: FROM jai_rgm_definitions

1581: WHERE invoice_id = pr_rec.invoice_id ;
1582:
1583: CURSOR get_regime_id_cur IS
1584: SELECT regime_id
1585: FROM jai_rgm_definitions
1586: WHERE regime_code = jai_constants.service_regime;
1587:
1588: CURSOR get_org_cur IS
1589: SELECT organization_id,location_id