DBA Data[Home] [Help]

APPS.PQH_RBC_STAGE dependencies on GL_DAILY_RATES

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

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

Line 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

Line 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