APPS.OTA_CANCEL_API dependencies on DUAL

Line 164: dual;

160: CURSOR c_sysdate IS
161: SELECT
162: sysdate
163: FROM
164: dual;
165:
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --

Line 323: select to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') into l_wf_date from dual;

319: l_different_hours := l_different_hours * 24 ;
320: IF l_different_hours <= nvl(l_cancel_hours,0) THEN
321: OPEN C_USER;
322: FETCH C_USER INTO l_user_name;
323: select to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') into l_wf_date from dual;
324:
325: OTA_INITIALIZATION_WF.MANUAL_WAITLIST(
326: p_itemtype => 'OTWF',
327: p_process => 'OTA_MANUAL_WAITLIST',

Line 543: dual;

539: CURSOR c_sysdate IS
540: SELECT
541: sysdate
542: FROM
543: dual;
544: --bug # 5231470 first date format changed to DD/MM/YYYY from DD-MON-YYYY
545: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
546: SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
547: OWNER_ID