APPS.JTF_DEBUG_PUB dependencies on V$PARAMETER

Line 325: FROM v$parameter

321: fnd_profile.get('UTL_FILE_LOG', l_dir);
322: if l_dir is null then
323: SELECT substr(value,1,instr(value,',',1,1)-1)
324: INTO l_dir
325: FROM v$parameter
326: WHERE name = 'utl_file_dir';
327: if l_dir is null then -- if there is only 1 directory
328: SELECT value
329: INTO l_dir

Line 330: FROM v$parameter

326: WHERE name = 'utl_file_dir';
327: if l_dir is null then -- if there is only 1 directory
328: SELECT value
329: INTO l_dir
330: FROM v$parameter
331: WHERE name = 'utl_file_dir';
332: end if;
333:
334: --fnd_profile.put('UTL_FILE_LOG',l_dir);