APPS.BIX_KPI_CLS_RPT_PKG dependencies on DUAL

Line 21: FROM dual;

17: BEGIN
18: /* Get the BIX conversion type */
19: SELECT fnd_profile.value('BIX_DM_CURR_CONVERSION_TYPE')
20: INTO l_conv_type
21: FROM dual;
22:
23: /* Get the exchange rate as per sysdate */
24: bix_util_pkg.get_conversion_rate(p_from_currency, p_to_currency, sysdate,
25: l_conv_type, p_denom_rate, p_num_rate, l_status);

Line 57: FROM dual;

53:
54: /* Fetch the time range (1 hour or 2 hour etc. ) preference of the user */
55: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
56: INTO l_time_range
57: FROM dual;
58:
59: /* If the user has not specified any time range then
60: report on 1/2 hour basis
61: */

Line 296: FROM dual;

292:
293: /* Fetch the sysdate into variable l_sysdate */
294: SELECT sysdate
295: INTO l_sysdate
296: FROM dual;
297:
298:
299: /* Get the JTF profile date format from the Profile */
300: g_date_format_mask := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

Line 392: FROM dual;

388:
389: /* Get the BIX global currency */
390: SELECT fnd_profile.value('BIX_DM_PREFERRED_CURRENCY')
391: INTO l_global_currency
392: FROM dual;
393:
394: /* Get the user currency */
395: SELECT fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')
396: INTO l_user_currency

Line 397: FROM dual;

393:
394: /* Get the user currency */
395: SELECT fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')
396: INTO l_user_currency
397: FROM dual;
398:
399: IF l_user_currency <> l_global_currency
400: THEN
401: /* Get exchange rate from BIX global currency to user preferred currency */