DBA Data[Home] [Help]

APPS.FND_TRACE dependencies on V$SESSION

Line 192: FROM V$SESSION S

188: IF PROF_FLAG = 'N' THEN -- Profiler has not been started yet.
189:
190: SELECT nvl(S.MODULE,'MOD_NA')
191: INTO MODULE_G
192: FROM V$SESSION S
193: WHERE AUDSID=USERENV('SESSIONID');
194:
195:
196: IF (FND_GLOBAL.LOGIN_ID > 0) then

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

446: -- Removed module from here as it gets reset for each form.
447:
448: SELECT S.SID,S.SERIAL#,P.SPID
449: INTO SESSION_ID_G,SERIAL#_G,SPID
450: FROM V$SESSION S, V$PROCESS P
451: WHERE S.PADDR=P.ADDR
452: AND AUDSID=USERENV('SESSIONID');
453:
454: -- changes done for bug 11077620