938: l_freq_conv := 1;
939: end if;
940: hr_utility.set_location('freq conv fctr is '||l_freq_conv,46);
941: if l_t_currency_code <> l_currency_code then
942: -- get the conv factor between currencies from gl_daily_rates
943: begin
944: select conversion_rate
945: into l_curr_conv
946: from gl_daily_rates
942: -- get the conv factor between currencies from gl_daily_rates
943: begin
944: select conversion_rate
945: into l_curr_conv
946: from gl_daily_rates
947: where from_currency = l_t_currency_code
948: and to_currency = l_currency_code
949: and conversion_date = (select max(conversion_date)
950: from gl_daily_rates
946: from gl_daily_rates
947: where from_currency = l_t_currency_code
948: and to_currency = l_currency_code
949: and conversion_date = (select max(conversion_date)
950: from gl_daily_rates
951: where from_currency = l_t_currency_code
952: and to_currency = l_currency_code
953: and conversion_date <= p_effective_date);
954: exception