APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 161: JAI_AR_TRX_TAX_LINES a ,

157: b.tax_type t_type ,
158: a.customer_trx_line_id line_id ,
159: a.tax_line_no tax_line_no -- added by sriram - 10/4/2003 - bug # 2769439
160: FROM
161: JAI_AR_TRX_TAX_LINES a ,
162: JAI_CMN_TAXES_ALL b
163: WHERE
164: link_to_cust_trx_line_id = v_customer_trx_line_id AND
165: a.tax_id = b.tax_id

Line 393: JAI_AR_TRX_TAX_LINES

389: CURSOR GET_COUNT(cn_customer_trx_line_id IN NUMBER)is
390: SELECT
391: COUNT(1)
392: FROM
393: JAI_AR_TRX_TAX_LINES
394: WHERE
395: link_to_cust_trx_line_id = cn_customer_trx_line_id ;
396:
397:

Line 1474: JAI_AR_TRX_TAX_LINES

1470: CURSOR GET_COUNT(cn_customer_trx_line_id IN NUMBER)is
1471: SELECT
1472: COUNT(1)
1473: FROM
1474: JAI_AR_TRX_TAX_LINES
1475: WHERE
1476: link_to_cust_trx_line_id = cn_customer_trx_line_id ;
1477: ------------------------------------------------------------------
1478: -- Added by zhiwei for GST get ccid by regime setup BUG#10233402 20101027 END

Line 1492: JAI_AR_TRX_TAX_LINES a ,

1488: b.tax_type t_type ,
1489: a.customer_trx_line_id line_id ,
1490: a.tax_line_no tax_line_no
1491: FROM
1492: JAI_AR_TRX_TAX_LINES a ,
1493: JAI_CMN_TAXES_ALL b
1494: WHERE
1495: link_to_cust_trx_line_id = pr_old.customer_trx_line_id and
1496: a.tax_id = b.tax_id

Line 2447: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta

2443: v_customer_trx_id, pr_old.customer_trx_line_id);
2444: /*Bug 8371741 - Start*/
2445: BEGIN
2446: SELECT max(jattl.tax_line_no) INTO l_tcs_sur_line_num
2447: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
2448: WHERE jattl.link_to_cust_trx_line_id = pr_new.customer_trx_line_id
2449: AND jattl.tax_id = jcta.tax_id
2450: AND jcta.tax_type = jai_constants.tax_type_tcs_surcharge
2451: GROUP BY jcta.tax_type;

Line 2459: FROM JAI_AR_TRX_TAX_LINES jattl

2455: END;
2456:
2457: BEGIN
2458: SELECT count(jattl.tax_line_no) INTO l_tot_tax_lines
2459: FROM JAI_AR_TRX_TAX_LINES jattl
2460: WHERE jattl.link_to_cust_trx_line_id = pr_new.customer_trx_line_id;
2461: EXCEPTION
2462: WHEN NO_DATA_FOUND THEN
2463: RETURN;

Line 2488: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta

2484: v_line_tax_amount := nvl(v_line_amount,0);
2485:
2486: BEGIN
2487: SELECT max(jattl.tax_line_no) INTO l_tcs_line_num
2488: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
2489: WHERE jattl.link_to_cust_trx_line_id = pr_new.customer_trx_line_id
2490: AND jattl.tax_id = jcta.tax_id
2491: AND jcta.tax_type = jai_constants.tax_type_tcs
2492: GROUP BY jcta.tax_type;

Line 2554: from JAI_AR_TRX_TAX_LINES jattl

2550: end if;
2551: end if; /** ln_threshold_slab_id is not null */
2552:
2553: select max(jattl.tax_line_no) into l_max_tax_line_no
2554: from JAI_AR_TRX_TAX_LINES jattl
2555: where jattl.link_to_cust_trx_line_id = pr_new.customer_trx_line_id;
2556:
2557: jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
2558: (