The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
competence_element_id,
object_version_number,
type,
business_group_id,
enterprise_id,
competence_id,
proficiency_level_id,
high_proficiency_level_id,
weighting_level_id,
rating_level_id,
person_id,
job_id,
valid_grade_id,
position_id,
organization_id,
parent_competence_element_id,
activity_version_id,
assessment_id,
assessment_type_id,
mandatory,
effective_date_from,
effective_date_to,
group_competence_type,
competence_type,
normal_elapse_duration,
normal_elapse_duration_unit,
sequence_number,
source_of_proficiency_level,
line_score,
certification_date,
certification_method,
next_certification_date,
comments,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
object_id,
object_name,
party_id -- HR/TCA merge
--
-- BUG3356369
--
,qualification_type_id
,unit_standard_type
,status
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,achieved_date
,appr_line_score
from per_competence_elements
where competence_element_id = p_competence_element_id;
select competence_element_id,
object_version_number,
type,
business_group_id,
enterprise_id,
competence_id,
proficiency_level_id,
high_proficiency_level_id,
weighting_level_id,
rating_level_id,
person_id,
job_id,
valid_grade_id,
position_id,
organization_id,
parent_competence_element_id,
activity_version_id,
assessment_id,
assessment_type_id,
mandatory,
effective_date_from,
effective_date_to,
group_competence_type,
competence_type,
normal_elapse_duration,
normal_elapse_duration_unit,
sequence_number,
source_of_proficiency_level,
line_score,
certification_date,
certification_method,
next_certification_date,
comments,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
object_id,
object_name,
party_id -- HR/TCA merge
--
-- BUG3356369
--
,qualification_type_id
,unit_standard_type
,status
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,achieved_date
,appr_line_score
from per_competence_elements
where competence_element_id = p_competence_element_id
for update nowait;