The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
rank_process_id
,pgm_id
,pl_id
,oipl_id
,process_cd
,process_date
,benefit_action_id
,person_id
,assignment_id
,total_score
,object_version_number
,request_id
,business_group_id
,per_in_ler_id
from pqh_rank_processes
where rank_process_id = p_rank_process_id;
select
rank_process_id
,pgm_id
,pl_id
,oipl_id
,process_cd
,process_date
,benefit_action_id
,person_id
,assignment_id
,total_score
,object_version_number
,request_id
,business_group_id
,per_in_ler_id
from pqh_rank_processes
where rank_process_id = p_rank_process_id
for update nowait;