The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
service_history_period_id
,business_group_id
,assignment_id
,start_date
,end_date
,employer_name
,employer_address
,employer_type
,employer_subtype
,period_years
,period_days
,description
,continuous_service
,all_assignments
,object_version_number
,shp_attribute_category
,shp_attribute1
,shp_attribute2
,shp_attribute3
,shp_attribute4
,shp_attribute5
,shp_attribute6
,shp_attribute7
,shp_attribute8
,shp_attribute9
,shp_attribute10
,shp_attribute11
,shp_attribute12
,shp_attribute13
,shp_attribute14
,shp_attribute15
,shp_attribute16
,shp_attribute17
,shp_attribute18
,shp_attribute19
,shp_attribute20
,shp_information_category
,shp_information1
,shp_information2
,shp_information3
,shp_information4
,shp_information5
,shp_information6
,shp_information7
,shp_information8
,shp_information9
,shp_information10
,shp_information11
,shp_information12
,shp_information13
,shp_information14
,shp_information15
,shp_information16
,shp_information17
,shp_information18
,shp_information19
,shp_information20
from pqp_service_history_periods
where service_history_period_id = p_service_history_period_id;
select
service_history_period_id
,business_group_id
,assignment_id
,start_date
,end_date
,employer_name
,employer_address
,employer_type
,employer_subtype
,period_years
,period_days
,description
,continuous_service
,all_assignments
,object_version_number
,shp_attribute_category
,shp_attribute1
,shp_attribute2
,shp_attribute3
,shp_attribute4
,shp_attribute5
,shp_attribute6
,shp_attribute7
,shp_attribute8
,shp_attribute9
,shp_attribute10
,shp_attribute11
,shp_attribute12
,shp_attribute13
,shp_attribute14
,shp_attribute15
,shp_attribute16
,shp_attribute17
,shp_attribute18
,shp_attribute19
,shp_attribute20
,shp_information_category
,shp_information1
,shp_information2
,shp_information3
,shp_information4
,shp_information5
,shp_information6
,shp_information7
,shp_information8
,shp_information9
,shp_information10
,shp_information11
,shp_information12
,shp_information13
,shp_information14
,shp_information15
,shp_information16
,shp_information17
,shp_information18
,shp_information19
,shp_information20
from pqp_service_history_periods
where service_history_period_id = p_service_history_period_id
for update nowait;