DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on ZX_RATES_B

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

187: tax lines into the AR transaction tables and it will not uptake ebTax, it would be mandatory for
188: IL to have setups under the ebTax that can be used in the above transactions.
189:
190: Fix:
191: Query logic is changed. Instead of querying vat_Tax_id from ar_vat_tax_all , tax_rate_id of zx_rates_b
192: is queried
193:
194: 14 25-Apr-2007 cbabu for Bug#6012570 (5876390), File Version 120.5 (115.5)
195: FP: Project billing implementation.

Line 1177: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

1173: l_xla_event arp_xla_events.xla_events_type;
1174: ln_gl_seq Number;
1175: imported_trx VARCHAR2(10) := 'IMPORTED';
1176:
1177: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
1178: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
1179: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
1180:
1181: localization_tax_not_defined EXCEPTION;

Line 1179: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

1175: imported_trx VARCHAR2(10) := 'IMPORTED';
1176:
1177: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
1178: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
1179: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
1180:
1181: localization_tax_not_defined EXCEPTION;
1182: Item_lines_already_accounted EXCEPTION; /* Ramanand for SLA Uptake */
1183: rounding_account_not_defined EXCEPTION;

Line 2423: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

2419: AND A.CUSTOMER_TRX_LINE_ID = C.CUSTOMER_TRX_LINE_ID;
2420:
2421:
2422: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2423: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
2424: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
2425: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
2426: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, end */
2427:

Line 2425: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

2421:
2422: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2423: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
2424: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
2425: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
2426: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, end */
2427:
2428: --2001/06/26 Anuradha Parthasarathy
2429: Cursor payment_schedule_cur IS