APPS.FND_ADG_MANAGE dependencies on V$SESSION

Line 77: from v$session a

73: cursor c1 is select a.dbid,a.name
74: from v$database a;
75:
76: cursor c2 is select a.sid,a.serial#,a.audsid
77: from v$session a
78: where a.sid = ( select distinct b.sid from v$mystat b);
79:
80: begin
81:

Line 182: from v$session a

178:
179: -- Don't use SESSIONID as invalid on standby!
180:
181: cursor c2 is select a.sid,a.serial#,a.audsid
182: from v$session a
183: where a.sid = ( select distinct b.sid from v$mystat b);
184:
185: l_valid number;
186: l_slave_session_id number;