DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

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

157:
158: --end
159: /*added by rchandan for bug #6030615*/
160: /*
161: ||Fetch the information from jai_mtl_trxs and jai_cmn_document_taxes
162: */
163: CURSOR cur_get_mtltxns
164: IS
165: SELECT

Line 176: jai_cmn_document_taxes jcdt,

172: jmt.creation_date,
173: jcdt.tax_amt
174: FROM
175: jai_mtl_trxs jmt,
176: jai_cmn_document_taxes jcdt,
177: jai_cmn_taxes_all jtc,
178: jai_rgm_registrations jrg,
179: jai_rgm_definitions jrr
180: WHERE

Line 269: jai_cmn_document_taxes jcdt ,

265: jcdt.tax_type tax_type
266: FROM
267: jai_pa_draft_invoices jpdi ,
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