The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT to_number(nvl(VALUE, 0)) INTO l_worker FROM v$parameter
WHERE NAME = 'job_queue_processes';
select idx_name from ctxsys.ctx_indexes
where idx_name=l_index_name
and upper(idx_owner)=UPPER('IBC');
SELECT COUNT(*) FROM dba_indexes
WHERE index_name = UPPER(p_index_name)
AND owner= UPPER(p_owner);
select count(*)
into l_num_pending_requests
from fnd_concurrent_programs cp,
fnd_application ap,
fnd_concurrent_requests cr
where ap.application_short_name = g_ibc_short_name
and cp.concurrent_program_name = l_sync_idx_progname
and cp.application_id = ap.application_id
and cr.concurrent_program_id = cp.concurrent_program_id
and cr.phase_code = l_pending_phase_code
and cr.requested_start_date <= sysdate;