The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
successor_in_plan_id
,plan_id
,successor_id
,business_group_id
,status
,potential
,performance_rating
,risk_of_loss
,impact_of_loss
,readiness_pct
,rank
,eligible_for_promotion
,earliest_succession_date
,latest_succession_date
,comments
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,planned_date
,assignment_id
,supervisor_id
,grade_id
,grade_ladder_id
,grade_step_id
,grade_point_id
,position_id
,job_id
,assignment_status_type_id
,organization_id
,people_group_id
,pay_basis_id
,employee_category
,bargaining_unit_code
,labour_union_member_flag
,collective_agreement_id
,assignment_category
,location_id
,contract_id
,object_version_number
from per_sp_successor_in_plan
where successor_in_plan_id = p_successor_in_plan_id;
select
successor_in_plan_id
,plan_id
,successor_id
,business_group_id
,status
,potential
,performance_rating
,risk_of_loss
,impact_of_loss
,readiness_pct
,rank
,eligible_for_promotion
,earliest_succession_date
,latest_succession_date
,comments
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,planned_date
,assignment_id
,supervisor_id
,grade_id
,grade_ladder_id
,grade_step_id
,grade_point_id
,position_id
,job_id
,assignment_status_type_id
,organization_id
,people_group_id
,pay_basis_id
,employee_category
,bargaining_unit_code
,labour_union_member_flag
,collective_agreement_id
,assignment_category
,location_id
,contract_id
,object_version_number
from per_sp_successor_in_plan
where successor_in_plan_id = p_successor_in_plan_id
for update nowait;