APPS.IEX_STRATEGY_WF dependencies on DUAL

Line 2783: select sysdate into l_execution_time from dual;

2779: END IF;
2780:
2781: --start fulfilment process
2782: If l_result = wf_yes THEN
2783: select sysdate into l_execution_time from dual;
2784: l_return := wf_no;
2785: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2786: iex_debug_pub.logMessage('cal_post_wait l_execution_time = ' ||l_execution_time);
2787: END IF;

Line 3033: from dual;

3029: -- wait for one day, the workflow background process will pick it up
3030: begin
3031: select sysdate + 1
3032: into l_restart_create_wi_time
3033: from dual;
3034: exception
3035: when others then
3036: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3037: iex_debug_pub.logMessage('wi_failed_first_time get sysdate time error ');

Line 3269: from dual;

3265: iex_debug_pub.logmessage ('**** BEGIN set_on_hold_wait ************');
3266: END IF;
3267: select sysdate+(23/24)
3268: into l_execution_time
3269: from dual;
3270: wf_engine.SetItemAttrDate(itemtype => itemtype,
3271: itemkey => itemkey,
3272: aname => 'ON_HOLD_WAIT_TIME',
3273: avalue => l_execution_time);