APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on V$PARAMETER

Line 122: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';

118: l_dummy NUMBER;
119:
120: BEGIN
121: SELECT value INTO l_dir
122: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';
123: l_log_begin := INSTR(l_dir, '/log');
124:
125: IF (l_log_begin = 0) THEN /* then get the first string */
126: l_utl_dir := substr(l_dir, 1, INSTR(l_dir, ',') - 1);