The following lines contain the word 'select', 'insert', 'update' or 'delete':
select assessment_type_id,
name,
business_group_id,
description,
rating_scale_id,
weighting_scale_id,
rating_scale_comment,
weighting_scale_comment,
assessment_classification,
display_assessment_comments,
date_from,
date_to,
comments,
instructions,
weighting_classification,
line_score_formula,
total_score_formula,
object_version_number,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
type,
line_score_formula_id,
default_job_competencies,
available_flag
from per_assessment_types
where assessment_type_id = p_assessment_type_id;
select
assessment_type_id,
name,
business_group_id,
description,
rating_scale_id,
weighting_scale_id,
rating_scale_comment,
weighting_scale_comment,
assessment_classification,
display_assessment_comments,
date_from,
date_to,
comments,
instructions,
weighting_classification,
line_score_formula,
total_score_formula,
object_version_number,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
type,
line_score_formula_id,
default_job_competencies,
available_flag
from per_assessment_types
where assessment_type_id = p_assessment_type_id
for update nowait;