APPS.CN_COLLECTION_AIA_OM_PUB dependencies on GL_DAILY_RATES

Line 68: FROM gl_daily_rates

64: p_org_id IN cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.exchange_rate%TYPE IS
65:
66: CURSOR c1(l_to_currency varchar2,l_conversion_type varchar2) IS
67: SELECT conversion_date
68: FROM gl_daily_rates
69: WHERE from_currency = p_from_currency
70: AND to_currency = l_to_currency
71: AND conversion_type = l_conversion_type
72: AND conversion_date = p_conversion_date

Line 78: FROM gl_daily_rates

74: ORDER BY conversion_date DESC;
75:
76: CURSOR c2(l_to_currency varchar2,l_conversion_type varchar2) IS
77: SELECT MAX(conversion_date) conversion_date
78: FROM gl_daily_rates
79: WHERE from_currency = p_from_currency
80: AND to_currency = l_to_currency
81: AND conversion_type = l_conversion_type
82: AND conversion_date < p_conversion_date;