The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sql_stmt := ' SELECT wdj.wip_entity_id
FROM wip_discrete_jobs wdj, eam_work_order_details ewod, csi_item_instances cii,wip_entities we,eam_org_maint_defaults eomd,
mtl_eam_locations mel
WHERE wdj.wip_entity_id = ewod.wip_entity_id
AND decode(wdj.maintenance_object_type,3, wdj.maintenance_object_id,NULL) = cii.instance_id(+)
AND wdj.wip_entity_id = we.wip_entity_id
AND wdj.organization_id=we.organization_id
AND wdj.organization_id = :p_org_id
AND eomd.object_id(+) = cii.instance_id
AND eomd.object_type(+)=50
AND eomd.organization_id(+)=:p_org_id
AND mel.location_id(+)=eomd.area_id';
l_where_clause := l_where_clause || ' AND EXISTS (SELECT 1
FROM wip_operations wo
WHERE wo.wip_entity_id = wdj.wip_entity_id
AND wo.organization_id=wdj.organization_id
AND wo.department_id = ' || p_assigned_department || ' ) ';