APPS.BIX_DM_SESSBYCAMP_PKG dependencies on DUAL

Line 350: INTO l_temp FROM DUAL;

346: SELECT TO_CHAR(l_begin_date,'YYYY/MM/DD')||
347: LPAD(TO_CHAR(l_begin_date,'HH24:'),3,'0')||
348: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_begin_date,'MI'))-29),
349: 0,'00',1,'30',-1,'00')
350: INTO l_temp FROM DUAL;
351:
352: l_period_start := TO_DATE(l_temp,'YYYY/MM/DDHH24:MI');
353: l_row_counter := 0;
354: WHILE ( l_period_start < l_end_date )

Line 507: INTO l_temp FROM DUAL;

503: SELECT TO_CHAR(l_begin_date,'YYYY/MM/DD')||
504: LPAD(TO_CHAR(l_begin_date,'HH24:'),3,'0') ||
505: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_begin_date,'MI'))-29),
506: 0,'00',1,'30',-1,'00')
507: INTO l_temp FROM DUAL;
508:
509: l_period_start := TO_DATE(l_temp,'YYYY/MM/DDHH24:MI');
510: l_row_counter := 0;
511: WHILE ( l_period_start < l_end_date )

Line 843: FROM DUAL;

839: LPAD(TO_CHAR(g_collect_start_date,'HH24:'),3,'0')||
840: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_start_date,'MI'))-29),
841: 0,'00:00',1,'30:00',-1,'00:00'), 'YYYY/MM/DDHH24:MI:SS')
842: INTO g_rounded_collect_start_date
843: FROM DUAL;
844:
845: /* Round the collection end date to nearest higher time bucket.
846: eg: if time is between 10:00 and 10:29 round it to 10:29:59
847: */

Line 854: FROM DUAL;

850: LPAD(TO_CHAR(g_collect_end_date,'HH24:'),3,'0')||
851: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_end_date,'MI'))-29),
852: 0,'29:59',1,'59:59',-1,'29:59'), 'YYYY/MM/DDHH24:MI:SS')
853: INTO g_rounded_collect_end_date
854: FROM DUAL;
855:
856: g_message := 'Collection Period : '||
857: to_char(g_rounded_collect_start_date,'DD-MON-YYYY HH24:MI:SS') || ' to '
858: || to_char(g_rounded_collect_end_date, 'DD-MON-YYYY HH24:MI:SS');