The following lines contain the word 'select', 'insert', 'update' or 'delete':
select add_months(pps.date_start,
12 + trunc(months_between(bact.effective_date,
pps.date_start
)/12) *12) finyear
into l_accrual_year_end
from per_periods_of_service pps,
per_all_assignments_f asg,
pay_payroll_actions bact,
pay_assignment_actions bal_assact
where bact.payroll_action_id = p_owner_payroll_action_id
and bal_assact.payroll_action_id = bact.payroll_action_id
and pps.period_of_service_id = asg.period_of_service_id
and asg.assignment_id = bal_assact.assignment_id
and bal_assact.assignment_action_id = p_owner_assignment_action_id
and bact.effective_date between asg.effective_start_date
and asg.effective_end_date;
select add_months(pps.date_start,
12 + trunc(months_between(bact.effective_date,
pps.date_start
)/12) *12) finyear
into l_accrual_year_end
from per_periods_of_service pps,
per_all_assignments_f asg,
pay_payroll_actions bact,
pay_assignment_actions bal_assact
where bact.payroll_action_id = p_owner_payroll_action_id
and bal_assact.payroll_action_id = bact.payroll_action_id
and pps.period_of_service_id = asg.period_of_service_id
and asg.assignment_id = bal_assact.assignment_id
and bal_assact.assignment_action_id = p_owner_assignment_action_id
and bact.effective_date between asg.effective_start_date
and asg.effective_end_date;
select date_earned
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select date_earned
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select date_earned
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select date_earned
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select date_earned
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select add_months(pps.date_start,
12 + trunc(months_between(bact.date_earned,
pps.date_start
)/12) *12) finyear
into l_expiry_date
from per_periods_of_service pps,
per_all_assignments_f asg,
pay_payroll_actions bact,
pay_assignment_actions bal_assact
where bact.payroll_action_id = p_owner_payroll_action_id
and bal_assact.payroll_action_id = bact.payroll_action_id
and pps.period_of_service_id = asg.period_of_service_id
and asg.assignment_id = bal_assact.assignment_id
and bal_assact.assignment_action_id = p_owner_assignment_action_id
and bact.date_earned between asg.effective_start_date
and asg.effective_end_date;
select date_earned
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select add_months(pps.date_start,
12 + trunc(months_between(bact.date_earned,
pps.date_start
)/12) *12) finyear
into l_expiry_date
from per_periods_of_service pps,
per_all_assignments_f asg,
pay_payroll_actions bact,
pay_assignment_actions bal_assact
where bact.payroll_action_id = p_owner_payroll_action_id
and bal_assact.payroll_action_id = bact.payroll_action_id
and pps.period_of_service_id = asg.period_of_service_id
and asg.assignment_id = bal_assact.assignment_id
and bal_assact.assignment_action_id = p_owner_assignment_action_id
and bact.date_earned between asg.effective_start_date
and asg.effective_end_date;