The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
previous_employer_id
,business_group_id
,person_id
,party_id
,start_date
,end_date
,period_years
,period_days
,employer_name
,employer_country
,employer_address
,employer_type
,employer_subtype
,description
,pem_attribute_category
,pem_attribute1
,pem_attribute2
,pem_attribute3
,pem_attribute4
,pem_attribute5
,pem_attribute6
,pem_attribute7
,pem_attribute8
,pem_attribute9
,pem_attribute10
,pem_attribute11
,pem_attribute12
,pem_attribute13
,pem_attribute14
,pem_attribute15
,pem_attribute16
,pem_attribute17
,pem_attribute18
,pem_attribute19
,pem_attribute20
,pem_attribute21
,pem_attribute22
,pem_attribute23
,pem_attribute24
,pem_attribute25
,pem_attribute26
,pem_attribute27
,pem_attribute28
,pem_attribute29
,pem_attribute30
,pem_information_category
,pem_information1
,pem_information2
,pem_information3
,pem_information4
,pem_information5
,pem_information6
,pem_information7
,pem_information8
,pem_information9
,pem_information10
,pem_information11
,pem_information12
,pem_information13
,pem_information14
,pem_information15
,pem_information16
,pem_information17
,pem_information18
,pem_information19
,pem_information20
,pem_information21
,pem_information22
,pem_information23
,pem_information24
,pem_information25
,pem_information26
,pem_information27
,pem_information28
,pem_information29
,pem_information30
,object_version_number
,all_assignments
,period_months
from per_previous_employers
where previous_employer_id = p_previous_employer_id;
select
previous_employer_id
,business_group_id
,person_id
,party_id
,start_date
,end_date
,period_years
,period_days
,employer_name
,employer_country
,employer_address
,employer_type
,employer_subtype
,description
,pem_attribute_category
,pem_attribute1
,pem_attribute2
,pem_attribute3
,pem_attribute4
,pem_attribute5
,pem_attribute6
,pem_attribute7
,pem_attribute8
,pem_attribute9
,pem_attribute10
,pem_attribute11
,pem_attribute12
,pem_attribute13
,pem_attribute14
,pem_attribute15
,pem_attribute16
,pem_attribute17
,pem_attribute18
,pem_attribute19
,pem_attribute20
,pem_attribute21
,pem_attribute22
,pem_attribute23
,pem_attribute24
,pem_attribute25
,pem_attribute26
,pem_attribute27
,pem_attribute28
,pem_attribute29
,pem_attribute30
,pem_information_category
,pem_information1
,pem_information2
,pem_information3
,pem_information4
,pem_information5
,pem_information6
,pem_information7
,pem_information8
,pem_information9
,pem_information10
,pem_information11
,pem_information12
,pem_information13
,pem_information14
,pem_information15
,pem_information16
,pem_information17
,pem_information18
,pem_information19
,pem_information20
,pem_information21
,pem_information22
,pem_information23
,pem_information24
,pem_information25
,pem_information26
,pem_information27
,pem_information28
,pem_information29
,pem_information30
,object_version_number
,all_assignments
,period_months
from per_previous_employers
where previous_employer_id = p_previous_employer_id
for update nowait;