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 438: FROM V$PROCESS P, V$SESSION S

434: Debug_Level := payload.Debug_Level;
435:
436: SELECT PID, SPID, S.AUDSID
437: INTO p_id, osp_id, s_id
438: FROM V$PROCESS P, V$SESSION S
439: WHERE S.AUDSID = USERENV('SESSIONID')
440: AND P.Addr = S.Paddr
441: and rownum <= 1; /* Probably not necessary */
442: