APPS.FND_SIGNON dependencies on V$PROCESS

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

187: -- have caused pid to change.
188: --
189: SELECT P.PID, P.SERIAL#, P.SPID
190: INTO l_pid, l_serial, l_spid
191: FROM V$PROCESS P, V$SESSION S
192: WHERE S.AUDSID = USERENV('SESSIONID')
193: AND S.PADDR = P.ADDR;
194:
195: UPDATE FND_LOGINS FL

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

271: -- Get current oracle and system process ids
272: begin
273: SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID
274: INTO local_pid, local_spid, local_serial#, local_process_spid
275: FROM V$PROCESS P, V$SESSION S
276: WHERE S.AUDSID = USERENV('SESSIONID')
277: AND S.PADDR = P.ADDR;
278: exception
279: when no_data_found then