APPS.BEN_RECN_REP dependencies on V$PARAMETER

Line 71: -- Get utl file dir from v$parameters change this query for only one dir

67: else
68: g_log_file_name := p_log_file_name;
69: end if;
70: --
71: -- Get utl file dir from v$parameters change this query for only one dir
72: -- in utl_file_dir
73: --
74: select decode(instr(value,','),0,value,
75: substrb(translate(ltrim(value),',',' '),

Line 79: from v$parameter

75: substrb(translate(ltrim(value),',',' '),
76: 1,
77: instr(translate(ltrim(value),',',' '),' ') - 1))
78: into l_audit_log_dir
79: from v$parameter
80: where name = 'utl_file_dir';
81:
82: -- Open the log File using FND routines
83: f_out := utl_file.fopen(l_audit_log_dir,g_log_file_name,'w',32767);