The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
training_plan_member_id
,training_plan_id
,activity_version_id
,activity_definition_id
,member_status_type_id
,target_completion_date
,business_group_id
,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
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,assignment_id
,source_id
,source_function
,cancellation_reason
,earliest_start_date
,creator_person_id
from ota_training_plan_members
where training_plan_member_id = p_training_plan_member_id;
select
training_plan_member_id
,training_plan_id
,activity_version_id
,activity_definition_id
,member_status_type_id
,target_completion_date
,business_group_id
,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
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,assignment_id
,source_id
,source_function
,cancellation_reason
,earliest_start_date
,creator_person_id
from ota_training_plan_members
where training_plan_member_id = p_training_plan_member_id
for update nowait;