APPS.IEX_STRATEGY_WF dependencies on DUAL

Line 3006: select sysdate into l_execution_time from dual;

3002: END IF;
3003:
3004: --start fulfilment process
3005: If l_result = wf_yes THEN
3006: select sysdate into l_execution_time from dual;
3007: l_return := wf_no;
3008: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3009: iex_debug_pub.logMessage('cal_post_wait l_execution_time = ' ||l_execution_time);
3010: END IF;

Line 3277: from dual;

3273: -- wait for one day, the workflow background process will pick it up
3274: begin
3275: select sysdate + 1
3276: into l_restart_create_wi_time
3277: from dual;
3278: exception
3279: when others then
3280: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3281: iex_debug_pub.logMessage('wi_failed_first_time get sysdate time error ');

Line 3577: from dual;

3573: iex_debug_pub.logmessage ('**** BEGIN set_on_hold_wait ************');
3574: END IF;
3575: select sysdate+(23/24)
3576: into l_execution_time
3577: from dual;
3578: wf_engine.SetItemAttrDate(itemtype => itemtype,
3579: itemkey => itemkey,
3580: aname => 'ON_HOLD_WAIT_TIME',
3581: avalue => l_execution_time);