DBA Data[Home] [Help]

APPS.BIM_I_BGT_FACTS_PKG dependencies on FII_CURRENCY

Line 1407: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),

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);

Line 1408: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)

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;

Line 2683: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),

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);

Line 2684: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)

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: