APPS.BIS_DEBUG_PUB SQL Statements

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

Line: 13

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

Line: 22

          select substr('l'|| substr(to_char(sysdate,'MI'),1,1)
                 || lpad(BIS_debug_s.nextval,6,'0'),1,8) || '.BIS'
          into G_FILE
          from dual;

Line: 43

G_Debug_tbl.DELETE;