377: begin
378: g_phase := 'Convert rate_type to rate_type_name';
379:
380: select user_conversion_type into g_prim_rate_type_name
381: from gl_daily_conversion_types
382: where conversion_type = g_prim_rate_type;
383:
384: if g_sec_rate_type is not null then
385: select user_conversion_type into g_sec_rate_type_name
382: where conversion_type = g_prim_rate_type;
383:
384: if g_sec_rate_type is not null then
385: select user_conversion_type into g_sec_rate_type_name
386: from gl_daily_conversion_types
387: where conversion_type = g_sec_rate_type;
388: else
389: g_sec_rate_type_name := null;
390: end if;