DBA Data[Home] [Help]

APPS.FND_TRACE dependencies on V$SESSION

Line 165: FROM V$SESSION S

161: IF PROF_FLAG = 'N' THEN -- Profiler has not been started yet.
162:
163: SELECT nvl(S.MODULE,'MOD_NA')
164: INTO MODULE_G
165: FROM V$SESSION S
166: WHERE AUDSID=USERENV('SESSIONID');
167:
168:
169: IF (FND_GLOBAL.LOGIN_ID > 0) then

Line 423: FROM V$SESSION S, V$PROCESS P

419: -- Removed module from here as it gets reset for each form.
420:
421: SELECT S.SID,S.SERIAL#,P.SPID
422: INTO SESSION_ID_G,SERIAL#_G,SPID
423: FROM V$SESSION S, V$PROCESS P
424: WHERE S.PADDR=P.ADDR
425: AND AUDSID=USERENV('SESSIONID');
426:
427: