[Home] [Help]
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
171: jmt.vat_assessable_value,
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