336: , FII_LOGIN_ID
337: from FII_TIME_MONTH prd
338: , HRI_CONVERT_FROM_CURRENCIES_V cfr
339: , ( select g_prim_currency currency_code, g_prim_rate_type rate_type
340: from dual
341: union all
342: select g_sec_currency currency_code, g_sec_rate_type rate_type
343: from dual
344: where g_sec_currency is not null
339: , ( select g_prim_currency currency_code, g_prim_rate_type rate_type
340: from dual
341: union all
342: select g_sec_currency currency_code, g_sec_rate_type rate_type
343: from dual
344: where g_sec_currency is not null
345: and g_sec_rate_type is not null
346: ) cto
347: where prd.end_date >= g_global_start_date;