DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on DUAL

Line 288: SELECT 'VAT REVERSAL' tax_type FROM DUAL

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
290: WHERE
291: jspl.organization_id = p_organization_id AND
292: jspl.location_id = p_location_id AND

Line 375: SELECT 'VAT REVERSAL' tax_type FROM DUAL

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
377: WHERE cp_source = jai_pa_billing_pkg.gv_source_projects
378: AND jpdi.draft_invoice_id = jpdil.draft_invoice_id
379: AND jpdil.draft_invoice_line_id = jcdt.source_doc_line_id

Line 421: FROM DUAL

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
422: ) jrttv
423: WHERE
424: jctl.customer_trx_id = p_customer_trx_id AND
425: jctl.customer_trx_line_id = jcttl.link_to_cust_trx_line_id AND