1403: prim_conversion_rate,
1404: sec_conversion_rate)
1405: SELECT from_currency,
1406: transaction_create_date,
1407: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
1408: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
1409: FROM (select distinct from_currency from_currency,
1410: transaction_create_date transaction_create_date
1411: from bim_i_budget_facts_stg);
1404: sec_conversion_rate)
1405: SELECT from_currency,
1406: transaction_create_date,
1407: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
1408: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
1409: FROM (select distinct from_currency from_currency,
1410: transaction_create_date transaction_create_date
1411: from bim_i_budget_facts_stg);
1412: commit;
2679: prim_conversion_rate,
2680: sec_conversion_rate)
2681: SELECT from_currency,
2682: transaction_create_date,
2683: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2684: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
2685: FROM (select distinct from_currency from_currency,
2686: transaction_create_date transaction_create_date
2687: from bim_i_budget_facts_stg);
2680: sec_conversion_rate)
2681: SELECT from_currency,
2682: transaction_create_date,
2683: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2684: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
2685: FROM (select distinct from_currency from_currency,
2686: transaction_create_date transaction_create_date
2687: from bim_i_budget_facts_stg);
2688: