The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
appraisal_period_id
,object_version_number
,plan_id
,appraisal_template_id
,start_date
,end_date
,task_start_date
,task_end_date
,initiator_code
,appraisal_system_type
,appraisal_type
,appraisal_assmt_status
,auto_conc_process
,days_before_task_st_dt
,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_appraisal_periods
where appraisal_period_id = p_appraisal_period_id;
select
appraisal_period_id
,object_version_number
,plan_id
,appraisal_template_id
,start_date
,end_date
,task_start_date
,task_end_date
,initiator_code
,appraisal_system_type
,appraisal_type
,appraisal_assmt_status
,auto_conc_process
,days_before_task_st_dt
,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_appraisal_periods
where appraisal_period_id = p_appraisal_period_id
for update nowait;