APPS.WF_DIAGNOSTICS_APPS dependencies on FND_CONCURRENT_PROCESSES

Line 48: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq

44: select VARIABLE_NAME, VALUE
45: from FND_ENV_CONTEXT
46: where CONCURRENT_PROCESS_ID in
47: (select max(CONCURRENT_PROCESS_ID)
48: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq
49: where fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID
50: and fcq.CONCURRENT_QUEUE_NAME= p_qname
51: and fcp.QUEUE_APPLICATION_ID = p_appId )
52: and VARIABLE_NAME in ('APPL_TOP', 'APPLCSF', 'APPLLOG', 'FND_TOP',

Line 182: -- fnd_concurrent_processes and gv$session

178: pmon_method => l_pmon_method,
179: callstat => l_callstat);
180:
181: -- l_callstat <>0 mean there is no process exist in
182: -- fnd_concurrent_processes and gv$session
183: IF l_callstat <> 0 THEN
184: l_temp_result := l_temp_result || ' could not get ' ||
185: ' actual and target process count ';
186: