APPS.FND_TRACE SQL Statements

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

Line: 33

  select substr(version,1,instr(version,'.')-1) into versn from v$instance;

Line: 67

      SELECT USER INTO DBUSER FROM DUAL;

Line: 190

       SELECT nvl(S.MODULE,'MOD_NA')
       INTO MODULE_G
       FROM V$SESSION S
       WHERE AUDSID=USERENV('SESSIONID');

Line: 212

       l_pl_str:='update plsql_profiler_runs set related_run=:RELATED_RUNID '||
                 'where runid=:PROF_RUNID';

Line: 308

     l_trc_cmd:='select sysdate into l_trc_cmd from dual';

Line: 448

   SELECT S.SID,S.SERIAL#,P.SPID
   INTO SESSION_ID_G,SERIAL#_G,SPID
   FROM V$SESSION S, V$PROCESS P
   WHERE S.PADDR=P.ADDR
     AND AUDSID=USERENV('SESSIONID');

Line: 457

   SELECT REPLACE(SUBSTR(version,1,instr(version,'.',1,2)-1),'.')
   INTO   db_versn
   FROM   v$instance;