DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 222: ||Fetch the information from jai_mtl_trxs and jai_cmn_document_taxes

218:
219: --end
220: /*added by rchandan for bug #6030615*/
221: /*
222: ||Fetch the information from jai_mtl_trxs and jai_cmn_document_taxes
223: */
224: CURSOR cur_get_mtltxns
225: IS
226: SELECT

Line 237: jai_cmn_document_taxes jcdt,

233: jmt.creation_date,
234: jcdt.tax_amt
235: FROM
236: jai_mtl_trxs jmt,
237: jai_cmn_document_taxes jcdt,
238: jai_cmn_taxes_all jtc,
239: jai_rgm_registrations jrg,
240: jai_rgm_definitions jrr
241: WHERE

Line 369: jai_cmn_document_taxes jcdt ,

365: jcdt.tax_type tax_type
366: FROM
367: jai_pa_draft_invoices jpdi ,
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