APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 157: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,

153: A.BASE_TAX_AMOUNT BASE_TAX_AMT,
154: b.tax_type t_type,
155: b.stform_type,
156: a.tax_line_no
157: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,
158: JAI_INV_ITM_SETUPS C
159: where link_to_cust_trx_line_id = p_line_id
160: and a.tax_id = b.tax_id
161: and c.inventory_item_id = p_inventory_item_id

Line 206: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

202: --AND NVL(location_id,0) = NVL(v_location_id,0);
203:
204: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
205: SELECT a.tax_rate, b.rounding_factor
206: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
207: WHERE a.tax_id = b.tax_id
208: AND a.link_to_cust_trx_line_id = p_cust_trx_line_id
209: AND b.tax_type = jai_constants.tax_type_modvat_recovery ;
210:

Line 239: jai_cmn_taxes_all jtc

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

Line 255: jai_cmn_taxes_all jtc

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