APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_CMN_TAXES_ALL

Line 152: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

148: a.tax_amount tax_amt,
149: b.tax_type t_type,
150: a.customer_trx_line_id line_id,
151: a.tax_line_no tax_line_no
152: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
153: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
154: AND a.tax_id = b.tax_id
155: AND NVL(b.reverse_charge_flag,'N') = 'N' --Added by Qinglei for bug#14619984 SERVICE TAX REVERSE CHARGE TAX LINE IS GENERATED IN AR DISTRIBUTION FORM
156: ORDER BY 1;

Line 181: FROM JAI_CMN_TAXES_ALL B

177: ln_tax_rate_id zx_rates_b.tax_rate_id%type;
178:
179: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
180: SELECT tax_account_id
181: FROM JAI_CMN_TAXES_ALL B
182: WHERE B.tax_id = p_tax_id;
183:
184: CURSOR CREATED_FROM_CUR IS
185: SELECT created_from,

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

254: SELECT trx_number
255: FROM ra_customer_trx_all
256: WHERE customer_trx_id = v_cust_trx_id;
257:
258: CURSOR cur_chk_rgm(cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
259: SELECT regime_id, regime_code
260: FROM jai_regime_tax_types_v jrttv
261: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
262:

Line 797: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta

793: IF v_created_from = 'ARXTWMAI' AND v_tax_exists = 1 THEN
794: BEGIN
795: SELECT max(jattl.tax_line_no)
796: INTO l_tcs_sur_line_num
797: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
798: WHERE jattl.link_to_cust_trx_line_id =
799: pr_new.customer_trx_line_id
800: AND jattl.tax_id = jcta.tax_id
801: AND jcta.tax_type = jai_constants.tax_type_tcs_surcharge

Line 849: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta

845:
846: BEGIN
847: SELECT max(jattl.tax_line_no)
848: INTO l_tcs_line_num
849: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
850: WHERE jattl.link_to_cust_trx_line_id =
851: pr_new.customer_trx_line_id
852: AND jattl.tax_id = jcta.tax_id
853: AND jcta.tax_type = jai_constants.tax_type_tcs