485: ,decode(curr_abs.absence_attendance_id,null,'N','Y') curr_abs
486: ,decode(future_abs.absence_attendance_id,null,'N','Y') future_abs
487: from per_all_assignments_f asg
488: ,per_pay_proposals ppp
489: ,per_absence_attendances curr_abs
490: ,per_absence_attendances future_abs
491: where asg.person_id = p_person_id
492: and asg.primary_flag = 'Y'
493: and asg.assignment_type in ('E','C')
486: ,decode(future_abs.absence_attendance_id,null,'N','Y') future_abs
487: from per_all_assignments_f asg
488: ,per_pay_proposals ppp
489: ,per_absence_attendances curr_abs
490: ,per_absence_attendances future_abs
491: where asg.person_id = p_person_id
492: and asg.primary_flag = 'Y'
493: and asg.assignment_type in ('E','C')
494: and p_eff_date between asg.effective_start_date and asg.effective_end_date