[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y'
into l_joiner
from pay_assignment_actions aa
,pay_payroll_actions pa
,per_all_assignments_f asg
,per_periods_of_service pos
where aa.assignment_action_id = p_asg_act_id
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = asg.assignment_id
and asg.period_of_service_id = pos.period_of_service_id
and trunc(POS.date_start, 'MM') = trunc(PA.effective_date, 'MM')
and pa.effective_date between ASg.effective_start_date
and ASg.effective_end_date;
select 'Y'
into l_leaver
from pay_assignment_actions aa
,pay_payroll_actions pa
,per_all_assignments_f asg
,per_periods_of_service POS
where aa.assignment_action_id = p_asg_act_id
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = asg.assignment_id
and asg.period_of_service_id = pos.period_of_service_id
and trunc(NVL(POS.actual_termination_date , TO_DATE('31/12/4712','DD/MM/YYYY')), 'MM') = trunc(PA.effective_date, 'MM')
and pa.effective_date between ASg.effective_start_date
and ASg.effective_end_date;
select nationality
into l_nationality_cd
from pay_assignment_actions aa
,pay_payroll_actions pa
,per_all_assignments_f asg
,per_all_people_f per
where aa.assignment_action_id = p_asg_act_id
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = asg.assignment_id
and asg.person_id = per.person_id
and pa.effective_date between ASg.effective_start_date
and ASg.effective_end_date
and pa.effective_date between PER.effective_start_date
and PER.effective_end_date;