DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 285: FROM jai_regime_tax_types_v jrttv1

281: JAI_OM_WSH_LINE_TAXES jsptl ,
282: JAI_CMN_TAXES_ALL jtc ,
283: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
284: SELECT jrttv1.tax_type tax_type
285: FROM jai_regime_tax_types_v jrttv1
286: WHERE jrttv1.regime_code = jai_constants.vat_regime --Modified by JMEENA from jrttv1.tax_type to jrttv1.regime_code for bug#6944839
287: UNION
288: SELECT 'VAT REVERSAL' tax_type FROM DUAL
289: ) jrttv

Line 372: FROM jai_regime_tax_types_v jrttv1

368: jai_pa_draft_invoice_lines jpdil ,
369: jai_cmn_document_taxes jcdt ,
370: (
371: SELECT jrttv1.tax_type tax_type
372: FROM jai_regime_tax_types_v jrttv1
373: WHERE jrttv1.regime_code = jai_constants.vat_regime
374: UNION
375: SELECT 'VAT REVERSAL' tax_type FROM DUAL
376: ) jrttv

Line 417: FROM jai_regime_tax_types_v jrttv1

413: JAI_AR_TRX_TAX_LINES jcttl ,
414: JAI_CMN_TAXES_ALL jtc ,
415: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
416: SELECT jrttv1.tax_type tax_type
417: FROM jai_regime_tax_types_v jrttv1
418: WHERE jrttv1.regime_code = jai_constants.vat_regime
419: UNION
420: SELECT 'VAT REVERSAL' tax_type
421: FROM DUAL