679: end if;
680: hr_utility.set_location('freq conv fctr is '||l_freq_conv,46);
681: if l_curr_cd <> l_crit_rate_rec.currency_code then
682: hr_utility.set_location('Conv from '||l_curr_cd||' To '||l_crit_rate_rec.currency_code,46);
683: -- get the conv factor between currencies from gl_daily_rates
684: begin
685: select conversion_rate
686: into l_curr_conv
687: from gl_daily_rates
683: -- get the conv factor between currencies from gl_daily_rates
684: begin
685: select conversion_rate
686: into l_curr_conv
687: from gl_daily_rates
688: where from_currency = l_curr_cd
689: and to_currency = l_crit_rate_rec.currency_code
690: and conversion_date = (select max(conversion_date)
691: from gl_daily_rates
687: from gl_daily_rates
688: where from_currency = l_curr_cd
689: and to_currency = l_crit_rate_rec.currency_code
690: and conversion_date = (select max(conversion_date)
691: from gl_daily_rates
692: where from_currency = l_curr_cd
693: and to_currency = l_crit_rate_rec.currency_code
694: and conversion_date <=p_effective_date);
695: exception