The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ptp.time_period_id
from pay_payroll_actions act
, per_time_periods ptp
where payroll_action_id = p_payroll_action_id
and act.date_earned between ptp.start_date and ptp.end_date
and act.payroll_id = ptp.payroll_id
and act.effective_date = p_effective_date;
select business_group_id
from pay_assignment_actions_v
where assignment_action_id = p_user_assignment_action_id;
select hr_nz_routes.span_start ( bptp.regular_payment_date
, p_frequency
, p_span_start )
from per_time_periods bptp
, pay_payroll_actions bact
where bact.payroll_action_id = p_user_payroll_action_id
and bact.effective_date = p_user_effective_date
and bact.payroll_id = bptp.payroll_id
and bact.date_earned between bptp.start_date and bptp.end_date;
select pptp.regular_payment_date
from per_time_periods pptp
, pay_payroll_actions pact
where pact.payroll_action_id = p_owner_payroll_action_id
and pact.effective_date = p_owner_effective_date
and pact.payroll_id = pptp.payroll_id
and pact.date_earned between pptp.start_date and pptp.end_date;