235: )
236: select transactional_curr_code from_currency,
237: time_activation_date_id conversion_date,
238: decode(transactional_curr_code, g_global_currency, 1,
239: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,
240: decode(transactional_curr_code, g_sec_global_currency, 1,
241: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
242: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
243: from isc_dbi_tmp_bsa_order_lines tmp);
237: time_activation_date_id conversion_date,
238: decode(transactional_curr_code, g_global_currency, 1,
239: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,
240: decode(transactional_curr_code, g_sec_global_currency, 1,
241: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
242: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
243: from isc_dbi_tmp_bsa_order_lines tmp);
244:
245: return(l_bsa_count);
944: )
945: select transactional_curr_code from_currency,
946: time_activation_date_id conversion_date,
947: decode(transactional_curr_code, g_global_currency, 1,
948: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,
949: decode(transactional_curr_code, g_sec_global_currency, 1,
950: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
951: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
952: from isc_dbi_tmp_bsa_order_lines tmp);
946: time_activation_date_id conversion_date,
947: decode(transactional_curr_code, g_global_currency, 1,
948: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,
949: decode(transactional_curr_code, g_sec_global_currency, 1,
950: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
951: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
952: from isc_dbi_tmp_bsa_order_lines tmp);
953:
954: fii_util.stop_timer;