The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(E.PERSON_ID),
'** ' || COUNT(E.PERSON_ID) ||' '|| X_MANAGER_NAME,
MAX(E.FULL_NAME),
MAX(E.EMPLOYEE_NUMBER)
INTO X_NO_OF_MANAGERS,
X_MANAGER_NAME,
l_real_manager_name,
X_MANAGER_EMP_NO
FROM PER_ALL_PEOPLE E
, PER_ALL_ASSIGNMENTS A
WHERE E.CURRENT_EMPLOYEE_FLAG = 'Y'
AND A.PERSON_ID = E.PERSON_ID
AND A.ORGANIZATION_ID = X_ORGANIZATION_ID
AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
AND A.ASSIGNMENT_TYPE = 'E'
AND A.MANAGER_FLAG = 'Y';