The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
element_type_id,
template_id,
classification_name,
additional_entry_allowed_flag,
adjustment_only_flag,
closed_for_entry_flag,
element_name,
indirect_only_flag,
multiple_entries_allowed_flag,
multiply_value_flag,
post_termination_rule,
process_in_run_flag,
relative_processing_priority,
processing_type,
standard_link_flag,
input_currency_code,
output_currency_code,
benefit_classification_name,
description,
qualifying_age,
qualifying_length_of_service,
qualifying_units,
reporting_name,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
element_information_category,
element_information1,
element_information2,
element_information3,
element_information4,
element_information5,
element_information6,
element_information7,
element_information8,
element_information9,
element_information10,
element_information11,
element_information12,
element_information13,
element_information14,
element_information15,
element_information16,
element_information17,
element_information18,
element_information19,
element_information20,
third_party_pay_only_flag,
skip_formula,
payroll_formula_id,
exclusion_rule_id,
iterative_flag,
iterative_priority,
iterative_formula_name,
process_mode,
grossup_flag,
advance_indicator,
advance_payable,
advance_deduction,
process_advance_entry,
proration_group,
proration_formula,
recalc_event_group,
once_each_period_flag,
object_version_number
from pay_shadow_element_types
where element_type_id = p_element_type_id;
select element_type_id,
template_id,
classification_name,
additional_entry_allowed_flag,
adjustment_only_flag,
closed_for_entry_flag,
element_name,
indirect_only_flag,
multiple_entries_allowed_flag,
multiply_value_flag,
post_termination_rule,
process_in_run_flag,
relative_processing_priority,
processing_type,
standard_link_flag,
input_currency_code,
output_currency_code,
benefit_classification_name,
description,
qualifying_age,
qualifying_length_of_service,
qualifying_units,
reporting_name,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
element_information_category,
element_information1,
element_information2,
element_information3,
element_information4,
element_information5,
element_information6,
element_information7,
element_information8,
element_information9,
element_information10,
element_information11,
element_information12,
element_information13,
element_information14,
element_information15,
element_information16,
element_information17,
element_information18,
element_information19,
element_information20,
third_party_pay_only_flag,
skip_formula,
payroll_formula_id,
exclusion_rule_id,
iterative_flag,
iterative_priority,
iterative_formula_name,
process_mode,
grossup_flag,
advance_indicator,
advance_payable,
advance_deduction,
process_advance_entry,
proration_group,
proration_formula,
recalc_event_group,
once_each_period_flag,
object_version_number
from pay_shadow_element_types
where element_type_id = p_element_type_id
for update nowait;