APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 224: FROM jai_regime_tax_types_v jrttv1

220: JAI_OM_WSH_LINE_TAXES jsptl ,
221: JAI_CMN_TAXES_ALL jtc ,
222: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
223: SELECT jrttv1.tax_type tax_type
224: FROM jai_regime_tax_types_v jrttv1
225: WHERE jrttv1.regime_code = jai_constants.vat_regime --Modified by JMEENA from jrttv1.tax_type to jrttv1.regime_code for bug#6944839
226: UNION
227: SELECT 'VAT REVERSAL' tax_type FROM DUAL
228: ) jrttv

Line 272: FROM jai_regime_tax_types_v jrttv1

268: jai_pa_draft_invoice_lines jpdil ,
269: jai_cmn_document_taxes jcdt ,
270: (
271: SELECT jrttv1.tax_type tax_type
272: FROM jai_regime_tax_types_v jrttv1
273: WHERE jrttv1.regime_code = jai_constants.vat_regime
274: UNION
275: SELECT 'VAT REVERSAL' tax_type FROM DUAL
276: ) jrttv

Line 316: FROM jai_regime_tax_types_v jrttv1

312: JAI_AR_TRX_TAX_LINES jcttl ,
313: JAI_CMN_TAXES_ALL jtc ,
314: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
315: SELECT jrttv1.tax_type tax_type
316: FROM jai_regime_tax_types_v jrttv1
317: WHERE jrttv1.regime_code = jai_constants.vat_regime
318: UNION
319: SELECT 'VAT REVERSAL' tax_type
320: FROM DUAL