[Home] [Help]
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
181: jmt.from_organization = p_organization_id
217: jtc.tax_type
218: FROM
219: JAI_OM_WSH_LINES_ALL jspl ,
220: JAI_OM_WSH_LINE_TAXES jsptl ,
221: JAI_CMN_TAXES_ALL jtc ,
222: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
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
309: jcttl.tax_rate
310: FROM
311: JAI_AR_TRX_LINES jctl ,
312: JAI_AR_TRX_TAX_LINES jcttl ,
313: JAI_CMN_TAXES_ALL jtc ,
314: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
315: SELECT jrttv1.tax_type tax_type
316: FROM jai_regime_tax_types_v jrttv1
317: WHERE jrttv1.regime_code = jai_constants.vat_regime
773: pv_source => p_source ,
774: pv_source_trx_type => lv_source_trx_type, /* Bug# 6012570 (5876390) jai_constants.source_ttype_delivery ,*/
775: pv_source_table_name => lv_source_table_name, /* Bug# 6012570 (5876390) jai_constants.tname_dlry_dtl ,*/
776: pn_source_id => ln_source_id, /* Bug# 6012570 (5876390) rec_cur_get_deliveries.delivery_detail_id ,*/
777: pv_reference_name => /*jai_constants.JAI_CMN_TAXES_ALL*/'JA_IN_TAX_CODES' ,
778: pn_reference_id => rec_cur_get_deliveries.tax_id
779: );
780:
781: if jai_pa_billing_pkg.gv_debug then
1351: pv_source => p_source ,
1352: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,
1353: pv_source_table_name => jai_constants.tname_cus_trx_lines ,
1354: pn_source_id => rec_cur_get_man_ar_inv_taxes.customer_trx_line_id ,
1355: pv_reference_name => /*jai_constants.JAI_CMN_TAXES_ALL*/ 'JA_IN_TAX_CODES' ,
1356: pn_reference_id => rec_cur_get_man_ar_inv_taxes.tax_id
1357: );
1358:
1359: IF lv_process_flag = jai_constants.expected_error OR