APPS.GMD_DEBUG dependencies on V$PARAMETER

Line 47: FROM v$parameter

43: LOG UTL_FILE.FILE_TYPE;
44:
45: CURSOR c_get_1st_location IS
46: SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value)
47: FROM v$parameter
48: WHERE name = 'utl_file_dir';
49:
50:
51:

Line 147: FROM v$parameter

143: l_file_name VARCHAR2(50);
144:
145: CURSOR c_get_1st_location IS
146: SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value)
147: FROM v$parameter
148: WHERE name = 'utl_file_dir';
149:
150: -- Bug 4576699: added l_log
151: l_log UTL_FILE.file_type;