The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor c_prsi_dtl is select contribution_class
,overridden_subclass
,soc_ben_flag
,overridden_ins_weeks
,community_flag
,exemption_start_date
,exemption_end_date
from pay_ie_prsi_details_v pipd
,pay_payroll_actions ppa
where assignment_id = p_assignment_id
and ppa.payroll_action_id = p_payroll_action_id
and ppa.date_earned between pipd.effective_start_date and pipd.effective_end_date;
select to_char(p_test_date, 'DAY') from sys.dual;
select pap.period_type
from pay_all_payrolls_f pap
where pap.payroll_id = p_payroll_id
and p_session_date between pap.effective_start_date and pap.effective_end_date;
select ptp.start_date
from per_time_periods ptp
where ptp.payroll_id = p_payroll_id
and p_session_date between ptp.start_date and ptp.end_date;
select ptp.end_date
from per_time_periods ptp
where ptp.payroll_id = p_payroll_id
and p_session_date between ptp.start_date and ptp.end_date;