The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(A.REC_AVAILABLE) into ieototal
from IEO_CP_LIST_STATS_ALL A, IEO_CP_SVC_LISTS_ALL B
where A.LIST_SRV_NAME = LIST_SRV_NAME_Value
and A.LIST_SRV_NAME = B.LIST_SRV_NAME
and A.LIST_NAME = B.LIST_NAME
and B.LIST_STATUS ='O';
select LIST_SRV_NAME from IEO_CP_SERVICES_ALL
where CAMPAIGN_LIST_ID in
(select DISTINCT(A.LIST_HEADER_ID)
from AMS_LIST_HEADERS_ALL A,
AMS_CAMPAIGN_SCHEDULES B
where A.LIST_USED_BY_ID = B.CAMPAIGN_SCHEDULE_ID
and B.CAMPAIGN_ID = CAMPAIGN_ID_Value);