APPS.FND_OAM_CPCHARTS_COL dependencies on GV$SESSION

Line 327: from fnd_concurrent_requests r, GV$SESSION WS

323: end if;
324:
325: if(p_metric_name = 'REQ_WAITING_ON_LOCK') then
326: select count(*) into ct_waiting_on_lock
327: from fnd_concurrent_requests r, GV$SESSION WS
328: where r.phase_code = 'R'
329: and r.oracle_session_id = WS.AUDSID
330: and WS.LOCKWAIT IS NOT NULL;
331: