APPS.PA_AUTOALLOC_WF_PKG dependencies on V$PARAMETER

Line 3197: FROM v$parameter

3193: -- use first entry of utl_file_dir as the TEMP_DIR
3194: -- if there is no entry then do not even construct file names
3195: SELECT TRANSLATE(LTRIM(value),',',' ')
3196: INTO TEMP_UTL
3197: FROM v$parameter
3198: WHERE name = 'utl_file_dir';
3199:
3200: IF (INSTR(TEMP_UTL,' ') > 0 AND TEMP_UTL IS NOT NULL) THEN
3201: SELECT SUBSTRB(TEMP_UTL, 1, INSTR(TEMP_UTL,' ') - 1)