APPS.FND_SIGNON dependencies on V$PROCESS

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

211: -- have caused pid to change.
212: --
213: SELECT P.PID, P.SERIAL#, P.SPID
214: INTO l_pid, l_serial, l_spid
215: FROM V$PROCESS P, V$SESSION S
216: WHERE S.AUDSID = USERENV('SESSIONID')
217: AND S.PADDR = P.ADDR;
218:
219: UPDATE FND_LOGINS FL

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

295: -- Get current oracle and system process ids
296: begin
297: SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID
298: INTO local_pid, local_spid, local_serial#, local_process_spid
299: FROM V$PROCESS P, V$SESSION S
300: WHERE S.AUDSID = USERENV('SESSIONID')
301: AND S.PADDR = P.ADDR;
302: exception
303: when no_data_found then