The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pa_request_extra_info_id,
pa_request_id,
information_type,
rei_attribute_category,
rei_attribute1,
rei_attribute2,
rei_attribute3,
rei_attribute4,
rei_attribute5,
rei_attribute6,
rei_attribute7,
rei_attribute8,
rei_attribute9,
rei_attribute10,
rei_attribute11,
rei_attribute12,
rei_attribute13,
rei_attribute14,
rei_attribute15,
rei_attribute16,
rei_attribute17,
rei_attribute18,
rei_attribute19,
rei_attribute20,
rei_information_category,
rei_information1,
rei_information2,
rei_information3,
rei_information4,
rei_information5,
rei_information6,
rei_information7,
rei_information8,
rei_information9,
rei_information10,
rei_information11,
rei_information12,
rei_information13,
rei_information14,
rei_information15,
rei_information16,
rei_information17,
rei_information18,
rei_information19,
rei_information20,
rei_information21,
rei_information22,
rei_information28,
rei_information29,
rei_information23,
rei_information24,
rei_information25,
rei_information26,
rei_information27,
rei_information30,
object_version_number,
request_id,
program_application_id,
program_id,
program_update_date
from ghr_pa_request_extra_info
where pa_request_extra_info_id = p_pa_request_extra_info_id;
select pa_request_extra_info_id,
pa_request_id,
information_type,
rei_attribute_category,
rei_attribute1,
rei_attribute2,
rei_attribute3,
rei_attribute4,
rei_attribute5,
rei_attribute6,
rei_attribute7,
rei_attribute8,
rei_attribute9,
rei_attribute10,
rei_attribute11,
rei_attribute12,
rei_attribute13,
rei_attribute14,
rei_attribute15,
rei_attribute16,
rei_attribute17,
rei_attribute18,
rei_attribute19,
rei_attribute20,
rei_information_category,
rei_information1,
rei_information2,
rei_information3,
rei_information4,
rei_information5,
rei_information6,
rei_information7,
rei_information8,
rei_information9,
rei_information10,
rei_information11,
rei_information12,
rei_information13,
rei_information14,
rei_information15,
rei_information16,
rei_information17,
rei_information18,
rei_information19,
rei_information20,
rei_information21,
rei_information22,
rei_information28,
rei_information29,
rei_information23,
rei_information24,
rei_information25,
rei_information26,
rei_information27,
rei_information30,
object_version_number,
request_id,
program_application_id,
program_id,
program_update_date
from ghr_pa_request_extra_info
where pa_request_extra_info_id = p_pa_request_extra_info_id
for update nowait;
p_program_update_date in date
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;