124: THEN
125: BEGIN
126: SELECT gdr.conversion_rate
127: INTO ln_exch_rate
128: FROM gl_daily_rates gdr
129: WHERE gdr.conversion_type = p_exchange_rate_type
130: AND gdr.from_currency = currency
131: AND gdr.to_currency = gc_func_currency
132: AND gdr.conversion_date = p_as_of_date;