DBA Data[Home] [Help]

APPS.FND_FILE dependencies on DUAL

Line 46: from sys.dual;

42: when OTHERS then
43: if (Sql%NotFound) then
44: select lpad(to_char(fnd_temp_files_s.nextval), 7, '0')
45: into BASE
46: from sys.dual;
47: end if;
48:
49: commit;
50: return BASE;

Line 283: from dual ;

279:
280: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
281: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
282: into TEMP_DIR
283: from dual ;
284: elsif (TEMP_UTL is not null) then
285: TEMP_DIR := TEMP_UTL;
286: end if;
287: