APPS.BIX_SESSION_SUMMARY_PKG dependencies on DUAL

Line 171: FROM dual;

167:
168: /* No of jobs to be submitted = No of days for which we need to collect data */
169: SELECT ceil(g_collect_end_date - g_collect_start_date)
170: INTO l_count
171: FROM dual;
172:
173: g_no_of_jobs := l_count;
174:
175: write_log('Number of workers that need to ne instantiated : ' || to_char(l_count));

Line 346: FROM DUAL;

342:
343: /* Get the half hour bucket of the session begin date time */
344: SELECT trunc(l_begin_date)
345: INTO l_period_start
346: FROM DUAL;
347:
348: l_row_counter := 0; /* Variable to identify the first row of the session in the while loop */
349:
350: /* Loop through the session record and insert a record for each half hour bucket */

Line 444: FROM dual ) change

440: USING (
441: SELECT
442: l_session_id(i) session_id,
443: l_collect_date(i) curr_collect_date
444: FROM dual ) change
445: ON ( bis1.session_id = change.session_id )
446: WHEN MATCHED THEN
447: UPDATE SET
448: bis1.curr_collect_date = change.curr_collect_date

Line 676: FROM DUAL;

672: IF (l_begin_date < l_end_date) THEN
673: /* Get the half hour bucket of the session begin date time */
674: SELECT trunc(l_begin_date)
675: INTO l_period_start
676: FROM DUAL;
677:
678: l_row_counter := 0; /* Variable to identify the first row of the session in the while loop */
679:
680: /* Loop through the session record and insert a record for each half hour bucket */

Line 944: FROM DUAL;

940: IF (l_begin_date < l_end_date) THEN
941: /* Get the half hour bucket of the session begin date time */
942: SELECT trunc(l_begin_date)
943: INTO l_period_start
944: FROM DUAL;
945:
946: l_row_counter := 0; /* Variable to identify the first row of the session in the while loop */
947:
948: /* Loop through the session record and insert a record for each half hour bucket */