[Home] [Help]
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
242: jmt.from_organization = p_organization_id
278: jtc.tax_type
279: FROM
280: JAI_OM_WSH_LINES_ALL jspl ,
281: JAI_OM_WSH_LINE_TAXES jsptl ,
282: JAI_CMN_TAXES_ALL jtc ,
283: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
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
410: jcttl.tax_line_no -- Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011
411: FROM
412: JAI_AR_TRX_LINES jctl ,
413: JAI_AR_TRX_TAX_LINES jcttl ,
414: JAI_CMN_TAXES_ALL jtc ,
415: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
416: SELECT jrttv1.tax_type tax_type
417: FROM jai_regime_tax_types_v jrttv1
418: WHERE jrttv1.regime_code = jai_constants.vat_regime
939: pv_source => p_source ,
940: pv_source_trx_type => lv_source_trx_type, /* Bug# 6012570 (5876390) jai_constants.source_ttype_delivery ,*/
941: pv_source_table_name => lv_source_table_name, /* Bug# 6012570 (5876390) jai_constants.tname_dlry_dtl ,*/
942: pn_source_id => ln_source_id, /* Bug# 6012570 (5876390) rec_cur_get_deliveries.delivery_detail_id ,*/
943: pv_reference_name => /*jai_constants.JAI_CMN_TAXES_ALL*/'JA_IN_TAX_CODES' ,
944: pn_reference_id => rec_cur_get_deliveries.tax_id
945: );
946:
947: if jai_pa_billing_pkg.gv_debug then
1563: pv_source => p_source ,
1564: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,
1565: pv_source_table_name => jai_constants.tname_cus_trx_lines ,
1566: pn_source_id => rec_cur_get_man_ar_inv_taxes.customer_trx_line_id ,
1567: pv_reference_name => /*jai_constants.JAI_CMN_TAXES_ALL*/ 'JA_IN_TAX_CODES' ,
1568: pn_reference_id => rec_cur_get_man_ar_inv_taxes.tax_id
1569: );
1570:
1571: IF lv_process_flag = jai_constants.expected_error OR