APPS.JTF_DEBUG_PUB dependencies on DUAL

Line 291: FROM dual;

287: ORDER BY log_sequence;
288:
289: CURSOR C_current_time IS
290: SELECT to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')
291: FROM dual;
292:
293: l_session_id NUMBER;
294: l_user_id NUMBER ;
295: l_dir VARCHAR2(2000);

Line 343: from dual;

339:
340: SELECT substr('l'|| substr(to_char(sysdate,'MI'),1,1)
341: || lpad(jtf_Debug_s.nextval,6,'0'),1,8) || '.dbg'
342: into l_filename
343: from dual;
344:
345: l_filetype := UTL_FILE.fopen(location => l_dir,
346: filename => l_filename,
347: open_mode=> 'a');