APPS.BIX_SESSION_LOAD_PKG dependencies on DUAL

Line 264: FROM DUAL;

260: IF (l_begin_date < l_end_date) THEN
261: /* Get the half hour bucket of the session begin date time */
262: SELECT trunc(l_begin_date)
263: INTO l_period_start
264: FROM DUAL;
265:
266: l_row_counter := 0; /* Variable to identify the first row of the session in the while loop */
267:
268: /* Loop through the session record and insert a record for each half hour bucket */

Line 520: FROM DUAL;

516: IF (l_begin_date < l_end_date) THEN
517: /* Get the half hour bucket of the session begin date time */
518: SELECT trunc(l_begin_date)
519: INTO l_period_start
520: FROM DUAL;
521:
522: l_row_counter := 0; /* Variable to identify the first row of the session in the while loop */
523:
524: /* Loop through the session record and insert a record for each half hour bucket */

Line 787: FROM DUAL;

783:
784: /* Get the half hour bucket of the session begin date time */
785: SELECT trunc(l_begin_date)
786: INTO l_period_start
787: FROM DUAL;
788:
789: l_row_counter := 0; /* Variable to identify the first row of the session in the while loop */
790:
791: /* Loop through the session record and insert a record for each half hour bucket */

Line 1307: FROM dual;

1303: WHERE report_date between trunc(p_start_date) and trunc(p_end_date);
1304:
1305: SELECT (trunc(p_end_date) - trunc(p_start_date)) + 1
1306: INTO l_count2
1307: FROM dual;
1308:
1309: IF (l_count1 < l_count2) THEN
1310: p_has_missing_date := TRUE;
1311: END IF;