The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
lp_enrollment_id
,learning_path_id
,person_id
,contact_id
,path_status_code
,enrollment_source_code
,no_of_mandatory_courses
,no_of_completed_courses
,completion_target_date
,completion_date
,creator_person_id
,object_version_number
,business_group_id
,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
,is_history_flag
from ota_lp_enrollments
where lp_enrollment_id = p_lp_enrollment_id;
select
lp_enrollment_id
,learning_path_id
,person_id
,contact_id
,path_status_code
,enrollment_source_code
,no_of_mandatory_courses
,no_of_completed_courses
,completion_target_date
,completion_date
,creator_person_id
,object_version_number
,business_group_id
,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
,is_history_flag
from ota_lp_enrollments
where lp_enrollment_id = p_lp_enrollment_id
for update nowait;