DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 346: jai_regime_tax_types_v jrttv

342: FROM
343: JAI_AR_TRX_TAX_LINES jcttl,
344: JAI_AR_TRX_LINES jctl,
345: JAI_CMN_TAXES_ALL jtc ,
346: jai_regime_tax_types_v jrttv
347: WHERE
348: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
349: jctl.customer_trx_id = pn_customer_trx_id AND
350: jcttl.tax_id = jtc.tax_id AND

Line 4810: from jai_regime_tax_types_v

4806: --start additions for bug#11652823
4807: cursor get_regime_id(cp_tax_type in varchar2)
4808: is
4809: select regime_id, regime_code /*Bug 11821537 - Added Regime Code*/
4810: from jai_regime_tax_types_v
4811: where regime_code in (jai_constants.service_regime,jai_constants.vat_regime)
4812: and tax_type=cp_tax_type;
4813:
4814: ln_regime_id number;