DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on DUAL

Line 227: SELECT 'VAT REVERSAL' tax_type FROM DUAL

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
229: WHERE
230: jspl.organization_id = p_organization_id AND
231: jspl.location_id = p_location_id AND

Line 275: SELECT 'VAT REVERSAL' tax_type FROM DUAL

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
277: WHERE cp_source = jai_pa_billing_pkg.gv_source_projects
278: AND jpdi.draft_invoice_id = jpdil.draft_invoice_id
279: AND jpdil.draft_invoice_line_id = jcdt.source_doc_line_id

Line 320: FROM DUAL

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
321: ) jrttv
322: WHERE
323: jctl.customer_trx_id = p_customer_trx_id AND
324: jctl.customer_trx_line_id = jcttl.link_to_cust_trx_line_id AND