The following lines contain the word 'select', 'insert', 'update' or 'delete':
select VARIABLE_NAME, VALUE
from FND_ENV_CONTEXT
where CONCURRENT_PROCESS_ID in
(select max(CONCURRENT_PROCESS_ID)
from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq
where fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID
and fcq.CONCURRENT_QUEUE_NAME= p_qname
and fcp.QUEUE_APPLICATION_ID = p_appId )
and VARIABLE_NAME in ('APPL_TOP', 'APPLCSF', 'APPLLOG', 'FND_TOP',
'AF_CLASSPATH', 'AFJVAPRG', 'AFJRETOP', 'CLASSPATH',
'PATH', 'LD_LIBRARY_PATH', 'ORACLE_HOME', 'NLS_LANG',
'AF_LD_LIBRARY_PATH')
order by VARIABLE_NAME;
select decode(fnd_profile.value('CONC_GSM_ENABLED'), 'Y', 'ENABLED', 'NOT ENABLED')
into l_gsm_enabled from dual;
SELECT application_id INTO l_app_id
FROM fnd_application
WHERE application_short_name = l_service_instances(i).application;
SELECT user_concurrent_queue_name,
concurrent_queue_id,
decode(enabled_flag, 'Y', 'ENABLED', 'NOT ENABLED')
INTO l_user_concurrent_queue_name, l_managerid, l_service_enabed
FROM fnd_concurrent_queues_vl
WHERE concurrent_queue_name = l_service_instances(i).instance_name;
select sysdate into l_date from dual;