The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor c1 is select position_id from hr_all_positions_f
where name = p_name
and effective_end_date = to_date('31124712','ddmmyyyy');
cursor c1 is select position_definition_id from hr_all_positions_f
where name = p_name
and effective_end_date = to_date('31124712','ddmmyyyy');
select payroll_id
from pay_all_payrolls_f pay, fnd_sessions f
where payroll_name = p_pay_freq_payroll_name
and f.effective_date between
pay.effective_start_date and pay.effective_end_date
and f.session_id = userenv ('sessionid')
and pay.business_group_id = p_business_group_id ;
select sps.step_id
from per_spinal_point_steps_f sps, per_spinal_points psp
where p_effective_date between sps.effective_start_date
and sps.effective_end_date
and sps.business_group_id = psp.business_group_id
and psp.business_group_id = p_business_group_id
and sps.spinal_point_id = psp.spinal_point_id
and psp.spinal_point = p_spinal_point ;
select shared_type_id
from per_shared_types_vl
where shared_type_name = p_shared_type_name
and lookup_type = 'POSITION_AVAILABILITY_STATUS'
and system_type_cd = p_system_type_cd
and nvl(business_group_id,p_business_group_id) = p_business_group_id;
cursor c1 is select object_version_number from hr_all_positions_f
where name = p_name
and effective_end_date = to_date('31124712','ddmmyyyy');