The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
case_group_id
,case_group_number
,description
,advanced_pay_grade
,entries_in_minute
,period_of_prob_advmnt
,period_of_time_advmnt
,advancement_to
,object_version_number
,advancement_additional_pyt
,time_advanced_pay_grade
,time_advancement_to
,business_group_id
,time_advn_units
,prob_advn_units
,sub_csgrp_description
from pqh_de_case_groups
where case_group_id = p_case_group_id;
select
case_group_id
,case_group_number
,description
,advanced_pay_grade
,entries_in_minute
,period_of_prob_advmnt
,period_of_time_advmnt
,advancement_to
,object_version_number
,advancement_additional_pyt
,time_advanced_pay_grade
,time_advancement_to
,business_group_id
,time_advn_units
,prob_advn_units
,sub_csgrp_description
from pqh_de_case_groups
where case_group_id = p_case_group_id
for update nowait;