The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
previous_job_usage_id
,assignment_id
,previous_employer_id
,previous_job_id
,start_date
,end_date
,period_years
,period_months
,period_days
,pju_attribute_category
,pju_attribute1
,pju_attribute2
,pju_attribute3
,pju_attribute4
,pju_attribute5
,pju_attribute6
,pju_attribute7
,pju_attribute8
,pju_attribute9
,pju_attribute10
,pju_attribute11
,pju_attribute12
,pju_attribute13
,pju_attribute14
,pju_attribute15
,pju_attribute16
,pju_attribute17
,pju_attribute18
,pju_attribute19
,pju_attribute20
,pju_information_category
,pju_information1
,pju_information2
,pju_information3
,pju_information4
,pju_information5
,pju_information6
,pju_information7
,pju_information8
,pju_information9
,pju_information10
,pju_information11
,pju_information12
,pju_information13
,pju_information14
,pju_information15
,pju_information16
,pju_information17
,pju_information18
,pju_information19
,pju_information20
,object_version_number
from per_previous_job_usages
where previous_job_usage_id = p_previous_job_usage_id;
select
previous_job_usage_id
,assignment_id
,previous_employer_id
,previous_job_id
,start_date
,end_date
,period_years
,period_months
,period_days
,pju_attribute_category
,pju_attribute1
,pju_attribute2
,pju_attribute3
,pju_attribute4
,pju_attribute5
,pju_attribute6
,pju_attribute7
,pju_attribute8
,pju_attribute9
,pju_attribute10
,pju_attribute11
,pju_attribute12
,pju_attribute13
,pju_attribute14
,pju_attribute15
,pju_attribute16
,pju_attribute17
,pju_attribute18
,pju_attribute19
,pju_attribute20
,pju_information_category
,pju_information1
,pju_information2
,pju_information3
,pju_information4
,pju_information5
,pju_information6
,pju_information7
,pju_information8
,pju_information9
,pju_information10
,pju_information11
,pju_information12
,pju_information13
,pju_information14
,pju_information15
,pju_information16
,pju_information17
,pju_information18
,pju_information19
,pju_information20
,object_version_number
from per_previous_job_usages
where previous_job_usage_id = p_previous_job_usage_id
for update nowait;