The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
person_deployment_id
,object_version_number
,from_business_group_id
,to_business_group_id
,from_person_id
,to_person_id
,person_type_id
,start_date
,end_date
,deployment_reason
,employee_number
,leaving_reason
,leaving_person_type_id
,permanent
,status
,status_change_reason
,status_change_date
,deplymt_policy_id
,organization_id
,location_id
,job_id
,position_id
,grade_id
,supervisor_id
,supervisor_assignment_id
,retain_direct_reports
,payroll_id
,pay_basis_id
,proposed_salary
,people_group_id
,soft_coding_keyflex_id
,assignment_status_type_id
,ass_status_change_reason
,assignment_category
,per_information_category
,per_information1
,per_information2
,per_information3
,per_information4
,per_information5
,per_information6
,per_information7
,per_information8
,per_information9
,per_information10
,per_information11
,per_information12
,per_information13
,per_information14
,per_information15
,per_information16
,per_information17
,per_information18
,per_information19
,per_information20
,per_information21
,per_information22
,per_information23
,per_information24
,per_information25
,per_information26
,per_information27
,per_information28
,per_information29
,per_information30
from hr_person_deployments
where person_deployment_id = p_person_deployment_id;
select
person_deployment_id
,object_version_number
,from_business_group_id
,to_business_group_id
,from_person_id
,to_person_id
,person_type_id
,start_date
,end_date
,deployment_reason
,employee_number
,leaving_reason
,leaving_person_type_id
,permanent
,status
,status_change_reason
,status_change_date
,deplymt_policy_id
,organization_id
,location_id
,job_id
,position_id
,grade_id
,supervisor_id
,supervisor_assignment_id
,retain_direct_reports
,payroll_id
,pay_basis_id
,proposed_salary
,people_group_id
,soft_coding_keyflex_id
,assignment_status_type_id
,ass_status_change_reason
,assignment_category
,per_information_category
,per_information1
,per_information2
,per_information3
,per_information4
,per_information5
,per_information6
,per_information7
,per_information8
,per_information9
,per_information10
,per_information11
,per_information12
,per_information13
,per_information14
,per_information15
,per_information16
,per_information17
,per_information18
,per_information19
,per_information20
,per_information21
,per_information22
,per_information23
,per_information24
,per_information25
,per_information26
,per_information27
,per_information28
,per_information29
,per_information30
from hr_person_deployments
where person_deployment_id = p_person_deployment_id
for update nowait;