APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_AR_TRX_TAX_LINES

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 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 811: FROM JAI_AR_TRX_TAX_LINES jattl

807:
808: BEGIN
809: SELECT count(jattl.tax_line_no)
810: INTO l_tot_tax_lines
811: FROM JAI_AR_TRX_TAX_LINES jattl
812: WHERE jattl.link_to_cust_trx_line_id =
813: pr_new.customer_trx_line_id;
814: EXCEPTION
815: WHEN NO_DATA_FOUND THEN

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

Line 910: from JAI_AR_TRX_TAX_LINES jattl

906: end if;
907:
908: select max(jattl.tax_line_no)
909: into l_max_tax_line_no
910: from JAI_AR_TRX_TAX_LINES jattl
911: where jattl.link_to_cust_trx_line_id =
912: pr_new.customer_trx_line_id;
913:
914: jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes(transaction_name => 'AR_LINES',