APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on ZX_RATES_B

Line 109: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

105: SELECT ORG_ID
106: FROM RA_CUSTOMER_TRX_ALL
107: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
108:
109: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
110: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
111: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
112: /* Added by Ramananda for bug#4468353 , end */
113:

Line 111: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

107: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
108:
109: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
110: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
111: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
112: /* Added by Ramananda for bug#4468353 , end */
113:
114:
115: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS

Line 943: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;

939: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id
940: AND account_class ='REC'
941: AND latest_rec_flag ='Y';
942:
943: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
944: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
945: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
946: /* Added by Ramananda for bug#4468353 , end */
947:

Line 945: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;

941: AND latest_rec_flag ='Y';
942:
943: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
944: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
945: ln_tax_rate_id zx_rates_b.tax_rate_id%type ;
946: /* Added by Ramananda for bug#4468353 , end */
947:
948: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
949: SELECT tax_account_id