APPS.WF_DIAGNOSTICS_APPS dependencies on FND_CONCURRENT_PROCESSES

Line 45: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq

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

Line 179: -- fnd_concurrent_processes and gv$session

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