The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select collective_agreement_id,
business_group_id,
object_version_number,
name,
status,
pl_id,
cag_number,
description,
start_date,
end_date,
employer_organization_id,
employer_signatory,
bargaining_organization_id,
bargaining_unit_signatory,
jurisdiction,
authorizing_body,
authorized_date,
cag_information_category,
cag_information1,
cag_information2,
cag_information3,
cag_information4,
cag_information5,
cag_information6,
cag_information7,
cag_information8,
cag_information9,
cag_information10,
cag_information11,
cag_information12,
cag_information13,
cag_information14,
cag_information15,
cag_information16,
cag_information17,
cag_information18,
cag_information19,
cag_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
from per_collective_agreements
where collective_agreement_id = p_collective_agreement_id;
/* select
collective_agreement_id,
business_group_id,
object_version_number,
name,
pl_id,
status,
cag_number,
description,
start_date,
end_date,
employer_organization_id,
employer_signatory,
bargaining_organization_id,
bargaining_unit_signatory,
jurisdiction,
authorizing_body,
authorized_date,
cag_information_category,
cag_information1,
cag_information2,
cag_information3,
cag_information4,
cag_information5,
cag_information6,
cag_information7,
cag_information8,
cag_information9,
cag_information10,
cag_information11,
cag_information12,
cag_information13,
cag_information14,
cag_information15,
cag_information16,
cag_information17,
cag_information18,
cag_information19,
cag_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20 */
--
l_proc varchar2(72) := g_package||'api_updating';
select
collective_agreement_id,
business_group_id,
object_version_number,
name,
status,
pl_id,
cag_number,
description,
start_date,
end_date,
employer_organization_id,
employer_signatory,
bargaining_organization_id,
bargaining_unit_signatory,
jurisdiction,
authorizing_body,
authorized_date,
cag_information_category,
cag_information1,
cag_information2,
cag_information3,
cag_information4,
cag_information5,
cag_information6,
cag_information7,
cag_information8,
cag_information9,
cag_information10,
cag_information11,
cag_information12,
cag_information13,
cag_information14,
cag_information15,
cag_information16,
cag_information17,
cag_information18,
cag_information19,
cag_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
from per_collective_agreements
where collective_agreement_id = p_collective_agreement_id
for update nowait;