DBA Data[Home] [Help]

APPS.ISC_DBI_BSA_OBJECTS_C dependencies on FII_CURRENCY

Line 239: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,

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

Line 241: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2

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

Line 948: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,

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

Line 950: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2

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;