APPS.FND_CONCURRENT dependencies on V$PROCESS

Line 1062: From V$Session S, V$Process P,

1058: Select P.PID, P.SPID, AUDSID, PROCESS,
1059: substr(userenv('LANGUAGE'),
1060: instr( userenv('LANGUAGE'), '.') + 1)
1061: Into cpid, csspid, csid, cspid, codeset
1062: From V$Session S, V$Process P,
1063: (select distinct sid from v$mystat ) m
1064: Where P.Addr = S.Paddr
1065: and s.sid = m.sid;
1066:

Line 1084: From V$Session S, V$Process P

1080: Select P.PID, P.SPID, AUDSID, PROCESS,
1081: substr(userenv('LANGUAGE'),
1082: instr( userenv('LANGUAGE'), '.') + 1)
1083: Into cpid, csspid, csid, cspid, codeset
1084: From V$Session S, V$Process P
1085: Where P.Addr = S.Paddr
1086: and S.AUDSID = userenv('SESSIONID');
1087:
1088: update fnd_concurrent_requests