APPS.PA_TASK_WORKFLOW_PKG dependencies on DUAL

Line 50: SELECT SYSDATE FROM SYS.DUAL;

46: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
47: FROM per_all_people_f papf
48: WHERE papf.person_id = e.person_id);
49: CURSOR c_wf_started_date IS
50: SELECT SYSDATE FROM SYS.DUAL;
51:
52: -- Cursor to fetch the complete change document information.
53: CURSOR c_ci_info IS
54: SELECT ci_id,

Line 115: FROM DUAL;

111: x_err_code := 0;
112: --get the unique identifier for this specific workflow
113: SELECT pa_workflow_itemkey_s.nextval
114: INTO itemkey
115: FROM DUAL;
116:
117: log_message('Initializing the variables',3);
118: -- Need this to populate the attribute information in Workflow
119: