APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 147: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,

143: A.BASE_TAX_AMOUNT BASE_TAX_AMT, --2001/03/30 Jagdish
144: b.tax_type t_type,
145: b.stform_type,
146: a.tax_line_no
147: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,
148: JAI_INV_ITM_SETUPS C
149: where link_to_cust_trx_line_id = p_line_id
150: and a.tax_id = b.tax_id
151: and c.inventory_item_id = p_inventory_item_id

Line 196: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

192: --AND NVL(location_id,0) = NVL(v_location_id,0);
193:
194: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
195: SELECT a.tax_rate, b.rounding_factor
196: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
197: WHERE a.tax_id = b.tax_id
198: AND a.link_to_cust_trx_line_id = p_cust_trx_line_id
199: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /*'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
200: --added by GD

Line 240: jai_cmn_taxes_all jtc

236: sum(jrcttl.func_tax_amount) cess_amount
237: FROM
238: jai_ar_trx_lines jrctl ,
239: jai_ar_trx_tax_lines jrcttl ,
240: jai_cmn_taxes_all jtc
241: WHERE
242: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
243: jrcttl.tax_id = jtc.tax_id AND
244: -- commented by ssawant

Line 257: jai_cmn_taxes_all jtc

253: sum(jrcttl.func_tax_amount) sh_cess_amount
254: FROM
255: jai_ar_trx_lines jrctl,
256: jai_ar_trx_tax_lines jrcttl,
257: jai_cmn_taxes_all jtc
258: WHERE
259: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
260: jrcttl.tax_id = jtc.tax_id AND
261: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND