APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on ZX_RATES_B

Line 202: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

198: SELECT ORG_ID
199: FROM RA_CUSTOMER_TRX_ALL
200: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
201:
202: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
203: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
204: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
205: /* Added by Ramananda for bug#4468353 , end */
206:

Line 204: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

200: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
201:
202: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
203: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
204: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
205: /* Added by Ramananda for bug#4468353 , end */
206:
207:
208: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS

Line 1540: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

1536: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id
1537: AND account_class ='REC'
1538: AND latest_rec_flag ='Y';
1539:
1540: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
1541: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
1542: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
1543: /* Added by Ramananda for bug#4468353 , end */
1544:

Line 1542: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

1538: AND latest_rec_flag ='Y';
1539:
1540: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
1541: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
1542: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
1543: /* Added by Ramananda for bug#4468353 , end */
1544:
1545: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
1546: SELECT tax_account_id