The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cn_repositories_s.nextval
INTO X_repository_id
FROM dual;
PROCEDURE select_columns (X_application_type IN OUT varchar2,
X_application_type_name IN OUT varchar2) IS
BEGIN
SELECT meaning INTO X_application_type_name
FROM cn_lookups
WHERE lookup_code = X_application_type
AND lookup_type = 'APPLICATION_TYPE';
END select_columns;