The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
veh_alloc_extra_info_id
,vehicle_allocation_id
,information_type
,vaei_attribute_category
,vaei_attribute1
,vaei_attribute2
,vaei_attribute3
,vaei_attribute4
,vaei_attribute5
,vaei_attribute6
,vaei_attribute7
,vaei_attribute8
,vaei_attribute9
,vaei_attribute10
,vaei_attribute11
,vaei_attribute12
,vaei_attribute13
,vaei_attribute14
,vaei_attribute15
,vaei_attribute16
,vaei_attribute17
,vaei_attribute18
,vaei_attribute19
,vaei_attribute20
,vaei_information_category
,vaei_information1
,vaei_information2
,vaei_information3
,vaei_information4
,vaei_information5
,vaei_information6
,vaei_information7
,vaei_information8
,vaei_information9
,vaei_information10
,vaei_information11
,vaei_information12
,vaei_information13
,vaei_information14
,vaei_information15
,vaei_information16
,vaei_information17
,vaei_information18
,vaei_information19
,vaei_information20
,vaei_information21
,vaei_information22
,vaei_information23
,vaei_information24
,vaei_information25
,vaei_information26
,vaei_information27
,vaei_information28
,vaei_information29
,vaei_information30
,object_version_number
,request_id
,program_application_id
,program_id
,program_update_date
from pqp_veh_alloc_extra_info
where veh_alloc_extra_info_id = p_veh_alloc_extra_info_id;
select
veh_alloc_extra_info_id
,vehicle_allocation_id
,information_type
,vaei_attribute_category
,vaei_attribute1
,vaei_attribute2
,vaei_attribute3
,vaei_attribute4
,vaei_attribute5
,vaei_attribute6
,vaei_attribute7
,vaei_attribute8
,vaei_attribute9
,vaei_attribute10
,vaei_attribute11
,vaei_attribute12
,vaei_attribute13
,vaei_attribute14
,vaei_attribute15
,vaei_attribute16
,vaei_attribute17
,vaei_attribute18
,vaei_attribute19
,vaei_attribute20
,vaei_information_category
,vaei_information1
,vaei_information2
,vaei_information3
,vaei_information4
,vaei_information5
,vaei_information6
,vaei_information7
,vaei_information8
,vaei_information9
,vaei_information10
,vaei_information11
,vaei_information12
,vaei_information13
,vaei_information14
,vaei_information15
,vaei_information16
,vaei_information17
,vaei_information18
,vaei_information19
,vaei_information20
,vaei_information21
,vaei_information22
,vaei_information23
,vaei_information24
,vaei_information25
,vaei_information26
,vaei_information27
,vaei_information28
,vaei_information29
,vaei_information30
,object_version_number
,request_id
,program_application_id
,program_id
,program_update_date
from pqp_veh_alloc_extra_info
where veh_alloc_extra_info_id = p_veh_alloc_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;