The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
objective_id
,object_version_number
,objective_name
,valid_from
,valid_to
,target_date
,next_review_date
,group_code
,priority_code
,appraise_flag
,weighting_percent
,measurement_style_code
,measure_name
,target_value
,uom_code
,measure_type_code
,measure_comments
,eligibility_type_code
,details
,success_criteria
,comments
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
from per_objectives_library
where objective_id = p_objective_id;
select
objective_id
,object_version_number
,objective_name
,valid_from
,valid_to
,target_date
,next_review_date
,group_code
,priority_code
,appraise_flag
,weighting_percent
,measurement_style_code
,measure_name
,target_value
,uom_code
,measure_type_code
,measure_comments
,eligibility_type_code
,details
,success_criteria
,comments
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
from per_objectives_library
where objective_id = p_objective_id
for update nowait;