APPS.BIX_CALLS_TYPE_RPT_PKG dependencies on DUAL

Line 275: FROM dual;

271:
272: /* Get the ICX Session Id */
273: SELECT icx_sec.g_session_id
274: INTO g_session_id
275: FROM dual;
276:
277: /* Delete the rows from the table bix_dm_report for the current icx session and report */
278: /* so that we donot display the leftover rows from the previous execution of the report */
279: DELETE bix_dm_report

Line 286: FROM dual;

282:
283: /* Fetch the sysdate into variable g_sysdate */
284: SELECT sysdate
285: INTO g_sysdate
286: FROM dual;
287:
288: /* Get the description of NULL */
289: g_null_desc := bix_util_pkg.get_null_lookup;
290:

Line 294: FROM dual;

290:
291: /* Fetch the time range (1 hour or 2 hour etc. ) preference of the user */
292: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
293: INTO g_time_range
294: FROM dual;
295:
296: /* If the user has not specified any time range then report on 1/2 hour basis */
297: IF g_time_range IS NULL THEN
298: g_time_range := 1;