The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT department_id INTO l_department_id
FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND B.NAME = p_x_req_resources.org_name
AND A.description = p_x_req_resources.dept_name;
SELECT department_id INTO l_department_id
FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND B.NAME = p_req_resources.org_name
AND A.description = p_req_resources.dept_name;