APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 162: JAI_CMN_TAXES_ALL b

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
166: and nvl(b.reverse_charge_flag,'N') = 'N' --Added by Qiong for reverse charge bug#16001407

Line 210: FROM JAI_CMN_TAXES_ALL B

206:
207:
208: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
209: SELECT tax_account_id
210: FROM JAI_CMN_TAXES_ALL B
211: WHERE B.tax_id = p_tax_id ;
212:
213: CURSOR CREATED_FROM_CUR IS
214: SELECT created_from, interface_header_attribute1,interface_header_attribute2

Line 313: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )

309: */
310: -------------------------------------------------------------------------
311: -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22 End
312:
313: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
314: IS
315: SELECT
316: regime_id ,
317: regime_code

Line 1493: JAI_CMN_TAXES_ALL b

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
1497: and nvl(b.reverse_charge_flag,'N') = 'N' --Added by Qiong for reverse charge bug#16001407

Line 1547: FROM JAI_CMN_TAXES_ALL B

1543: /* Added by Ramananda for bug#4468353 , end */
1544:
1545: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
1546: SELECT tax_account_id
1547: FROM JAI_CMN_TAXES_ALL B
1548: WHERE B.tax_id = p_tax_id ;
1549:
1550: CURSOR GL_DATE_CUR IS
1551: SELECT gl_date

Line 1584: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )

1580: /* Bug 5243532. Added by Lakshmi Gopalsami
1581: * Removed cursor set_of_books_cur and c_opr_set_of_books_id
1582: * and implemented caching logic.
1583: */
1584: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
1585: IS
1586: SELECT
1587: regime_id ,
1588: regime_code

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 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;