The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(sum(running_processes),0) into v_running_processes from fnd_concurrent_worker_requests where
(CONTROL_CODE not in ('D', 'T', 'E', 'X', 'R', 'N') OR CONTROL_CODE is NULL)
and request_id=P_REQUEST_ID;
ELSIF ((l_dev_status = 'DELETED') OR (l_dev_status = 'TERMINATED')) THEN
--Here there are 2 deviation from Original Specification.
--Cancelled cahnged to DELETED and Terminating changed to TERMINATED
--Cancelled- DELETED | Terminating - TERMINATED
l_image_name := 'cancelind_active.gif';