DBA Data[Home] [Help]

APPS.CN_MASS_ADJUST_UTIL dependencies on GL_DAILY_RATES

Line 58: FROM gl_daily_rates

54:
55: --
56: CURSOR c1 IS
57: SELECT conversion_date
58: FROM gl_daily_rates
59: WHERE from_currency = p_from_currency
60: AND to_currency = p_to_currency
61: AND conversion_type = p_conversion_type
62: AND conversion_date = p_conversion_date

Line 67: FROM gl_daily_rates

63: AND rownum < 2
64: ORDER BY conversion_date DESC;
65: CURSOR c2 IS
66: SELECT MAX(conversion_date) conversion_date
67: FROM gl_daily_rates
68: WHERE from_currency = p_from_currency
69: AND to_currency = p_to_currency
70: AND conversion_type = p_conversion_type
71: AND conversion_date < p_conversion_date;