DBA Data[Home] [Help]

APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 489: ,per_absence_attendances curr_abs

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')

Line 490: ,per_absence_attendances future_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')
494: and p_eff_date between asg.effective_start_date and asg.effective_end_date