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,
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,
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,
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,
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,
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,