APPS.JAI_AR_MATCH_TAX_PKG dependencies on AR_VAT_TAX_ALL

Line 517: Query logic is changed. Instead of querying vat_Tax_id from ar_vat_tax_all , tax_rate_id of zx_rates_b

513: tax lines into the AR transaction tables and it will not uptake ebTax, it would be mandatory for
514: IL to have setups under the ebTax that can be used in the above transactions.
515:
516: Fix:
517: Query logic is changed. Instead of querying vat_Tax_id from ar_vat_tax_all , tax_rate_id of zx_rates_b
518: is queried
519:
520: 14 25-Apr-2007 cbabu for Bug#6012570 (5876390), File Version 120.5 (115.5)
521: FP: Project billing implementation.

Line 2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;

2144: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
2145: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2146: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2147: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
2149: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;
2150: lv_account_Set_flag ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE;
2151: ln_precision fnd_currencies.precision%TYPE;
2152: ln_accounting_rule_id NUMBER;

Line 2149: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;

2145: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2146: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2147: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
2149: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;
2150: lv_account_Set_flag ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE;
2151: ln_precision fnd_currencies.precision%TYPE;
2152: ln_accounting_rule_id NUMBER;
2153: ln_old_amount NUMBER;