DBA Data[Home] [Help]

APPS.PQH_RBC_RATE_RETRIEVAL dependencies on GL_DAILY_RATES

Line 942: -- get the conv factor between currencies from gl_daily_rates

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

Line 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

Line 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