The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
corps_definition_id
,business_group_id
,name
,status_cd
,retirement_age
,category_cd
,recruitment_end_date
,corps_type_cd
,starting_grade_step_id
,task_desc
,secondment_threshold
,normal_hours
,normal_hours_frequency
,minimum_hours
,minimum_hours_frequency
,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
,attribute_category
,object_version_number
,type_of_ps
,date_from
,date_to
,primary_prof_field_id
,starting_grade_id
,ben_pgm_id
,probation_period
,probation_units
from pqh_corps_definitions
where corps_definition_id = p_corps_definition_id;
select
corps_definition_id
,business_group_id
,name
,status_cd
,retirement_age
,category_cd
,recruitment_end_date
,corps_type_cd
,starting_grade_step_id
,task_desc
,secondment_threshold
,normal_hours
,normal_hours_frequency
,minimum_hours
,minimum_hours_frequency
,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
,attribute_category
,object_version_number
,type_of_ps
,date_from
,date_to
,primary_prof_field_id
,starting_grade_id
,ben_pgm_id
,probation_period
,probation_units
from pqh_corps_definitions
where corps_definition_id = p_corps_definition_id
for update nowait;