APPS.IEU_SH_PVT dependencies on DUAL

Line 375: SELECT SYSDATE INTO l_begin_date_time FROM DUAL;

371: l_last_activity_id := P_PARENT_CYCLE_ID;
372: END IF;
373:
374: -- the default begin_date_time is the current systime
375: SELECT SYSDATE INTO l_begin_date_time FROM DUAL;
376:
377: -- if this is the first activity in the cycle then get the begin_date_time
378: -- for the cycle
379: -- if this is an intermediate activity get the end_date_time of the

Line 769: SELECT SYSDATE INTO l_end_date_time FROM DUAL;

765: -- the default end_date_time is the current time
766: -- if the last activity id is passed this is a MEDIA_CYCLE ending..
767: -- set the end_date_time as the end time of the last activity
768:
769: SELECT SYSDATE INTO l_end_date_time FROM DUAL;
770:
771: IF ( P_LAST_ACTIVITY_ID IS NOT NULL )
772: THEN
773: SELECT END_DATE_TIME INTO l_end_date_time FROM IEU_SH_ACTIVITIES WHERE