The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nota_history_id,
person_id,
contact_id,
trng_title,
provider,
type,
centre,
completion_date,
award,
rating,
duration,
duration_units,
activity_version_id,
status,
verified_by_id,
nth_information_category,
nth_information1,
nth_information2,
nth_information3,
nth_information4,
nth_information5,
nth_information6,
nth_information7,
nth_information8,
nth_information9,
nth_information10,
nth_information11,
nth_information12,
nth_information13,
nth_information15,
nth_information16,
nth_information17,
nth_information18,
nth_information19,
nth_information20,
org_id,
object_version_number,
business_group_id,
nth_information14,
customer_id,
organization_id
from ota_notrng_histories
where nota_history_id = p_nota_history_id;
select nota_history_id,
person_id,
contact_id,
trng_title,
provider,
type,
centre,
completion_date,
award,
rating,
duration,
duration_units,
activity_version_id,
status,
verified_by_id,
nth_information_category,
nth_information1,
nth_information2,
nth_information3,
nth_information4,
nth_information5,
nth_information6,
nth_information7,
nth_information8,
nth_information9,
nth_information10,
nth_information11,
nth_information12,
nth_information13,
nth_information15,
nth_information16,
nth_information17,
nth_information18,
nth_information19,
nth_information20,
org_id,
object_version_number,
business_group_id,
nth_information14,
customer_id,
organization_id
from ota_notrng_histories
where nota_history_id = p_nota_history_id
for update nowait;