R12 upgradation support
Can some suggest which table and column to replace with below 11i . Some blogs says, use gl_daily_rates but in that, i am not finding Period_name & Actual_flag. Please suggest.
SELECT ROUND(avg_rate,2)
INTO exch_rate
FROM gl_translation_rates_v
WHERE set_of_books_id = sob_id
AND functional_currency = from_curr
AND to_currency_code = to_curr
AND actual_flag = balance_type
AND period_name = period;
Thank you.