APPS.MSC_GET_PROFILE dependencies on V$PARAMETER

Line 158: select nvl(substr(value,1,instr(value,',')-1),value) from v$parameter where name = 'utl_file_dir';

154: AND (SITE_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y')
155: AND UPPER(USER_PROFILE_OPTION_NAME) LIKE prod||'%';
156:
157: CURSOR get_dir is
158: select nvl(substr(value,1,instr(value,',')-1),value) from v$parameter where name = 'utl_file_dir';
159:
160: var1 varchar2(240);
161: var2 BOOLEAN;
162: var4 BOOLEAN :=TRUE;