APPS.IEX_DEBUG_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

            select value  INTO G_DIR
 	        from v$PARAMETER where name = 'utl_file_dir';

Line: 33

            SELECT DB_NAME || USERENV('SESSIONID') || '.IEX' into G_FILE
            FROM   DUAL;

Line: 106

   SELECT NAME INTO DB_NAME FROM V$DATABASE;