APPS.FND_CP_GSM_IPC dependencies on V$PROCESS

Line 391: osp_id v$process.spid%TYPE := Null;

387: more_f Varchar2(1);
388:
389: s_id number;
390: p_id number;
391: osp_id v$process.spid%TYPE := Null;
392: sqlnet_str varchar2(30) := Null;
393: service_name varchar2(30) := Null;
394: que_rcg varchar2(32) := Null;
395: old_rcg varchar2(32);

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

424: Debug_Level := payload.Debug_Level;
425:
426: SELECT PID, SPID, S.AUDSID
427: INTO p_id, osp_id, s_id
428: FROM V$PROCESS P, V$SESSION S
429: WHERE S.AUDSID = USERENV('SESSIONID')
430: AND P.Addr = S.Paddr
431: and rownum <= 1; /* Probably not necessary */
432: