DBA Data[Home] [Help]

APPS.FND_OAM dependencies on V$SESSION

Line 59: from fnd_login_responsibilities r, v$session s

55: procedure APPS_SESSIONS(logins out nocopy number, forms out nocopy number) is
56: begin
57: select count(distinct(r.login_id))
58: into logins
59: from fnd_login_responsibilities r, v$session s
60: where r.audsid = s.audsid;
61:
62: select count(*)
63: into forms

Line 64: from fnd_login_resp_forms f, v$session s

60: where r.audsid = s.audsid;
61:
62: select count(*)
63: into forms
64: from fnd_login_resp_forms f, v$session s
65: where f.audsid = s.audsid;
66: end;
67:
68: