DBA Data[Home] [Help]

APPS.ASO_BI_POPULATE_FACTS dependencies on FII_CURRENCY

Line 34: FII_CURRENCY.get_rate(txn_currency,

30:
31: MERGE INTO ASO_BI_CURRENCY_RATES RATES
32: USING (SELECT txn_currency,
33: exchange_date,
34: FII_CURRENCY.get_rate(txn_currency,
35: g_prim_currency,
36: exchange_date,
37: l_rate_type) prim_conversion_rate,
38: FII_CURRENCY.get_rate(txn_currency,

Line 38: FII_CURRENCY.get_rate(txn_currency,

34: FII_CURRENCY.get_rate(txn_currency,
35: g_prim_currency,
36: exchange_date,
37: l_rate_type) prim_conversion_rate,
38: FII_CURRENCY.get_rate(txn_currency,
39: g_sec_currency,
40: exchange_date,
41: l_sec_rate_type) sec_conversion_rate,
42: FII_CURRENCY.get_rate(txn_currency,

Line 42: FII_CURRENCY.get_rate(txn_currency,

38: FII_CURRENCY.get_rate(txn_currency,
39: g_sec_currency,
40: exchange_date,
41: l_sec_rate_type) sec_conversion_rate,
42: FII_CURRENCY.get_rate(txn_currency,
43: func_currency_code,
44: exchange_date,
45: l_func_rate_type) func_conversion_rate,
46: func_currency_code,

Line 94: FII_CURRENCY.get_rate(txn_currency,

90: ELSE -- incremental
91: MERGE INTO ASO_BI_CURRENCY_RATES RATES
92: USING (SELECT txn_currency,
93: exchange_date,
94: FII_CURRENCY.get_rate(txn_currency,
95: g_prim_currency,
96: exchange_date,
97: l_rate_type) prim_conversion_rate,
98: FII_CURRENCY.get_rate(txn_currency,

Line 98: FII_CURRENCY.get_rate(txn_currency,

94: FII_CURRENCY.get_rate(txn_currency,
95: g_prim_currency,
96: exchange_date,
97: l_rate_type) prim_conversion_rate,
98: FII_CURRENCY.get_rate(txn_currency,
99: g_sec_currency,
100: exchange_date,
101: l_sec_rate_type) sec_conversion_rate,
102: FII_CURRENCY.get_rate(txn_currency,

Line 102: FII_CURRENCY.get_rate(txn_currency,

98: FII_CURRENCY.get_rate(txn_currency,
99: g_sec_currency,
100: exchange_date,
101: l_sec_rate_type) sec_conversion_rate,
102: FII_CURRENCY.get_rate(txn_currency,
103: func_currency_code,
104: exchange_date,
105: l_func_rate_type) func_conversion_rate,
106: func_currency_code,