DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on ZX_RATES_B

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 1778: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

1774: l_xla_event arp_xla_events.xla_events_type;
1775: ln_gl_seq Number;
1776: imported_trx VARCHAR2(10) := 'IMPORTED';
1777:
1778: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
1779: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
1780: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
1781:
1782: localization_tax_not_defined EXCEPTION;

Line 1780: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

1776: imported_trx VARCHAR2(10) := 'IMPORTED';
1777:
1778: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
1779: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
1780: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
1781:
1782: localization_tax_not_defined EXCEPTION;
1783: Item_lines_already_accounted EXCEPTION; /* Ramanand for SLA Uptake */
1784: rounding_account_not_defined EXCEPTION;

Line 3333: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

3329: and NVL(inclusive_tax_flag,'N') = 'N'));
3330:
3331:
3332: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
3333: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
3334: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
3335: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
3336: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, end */
3337:

Line 3335: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

3331:
3332: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
3333: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
3334: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
3335: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
3336: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, end */
3337:
3338: --2001/06/26 Anuradha Parthasarathy
3339: Cursor payment_schedule_cur IS