DBA Data[Home] [Help]

APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 442: from per_all_assignments_f asg

438: select date_start
439: ,actual_termination_date
440: ,final_process_date
441: ,projected_termination_date
442: from per_all_assignments_f asg
443: ,per_periods_of_service pds
444: where asg.person_id = p_person_id
445: and p_effective_date between
446: asg.effective_start_date and asg.effective_end_date

Line 487: from per_all_assignments_f asg

483: ,decode(asg.position_id, null, 'Y', 'N') no_position
484: ,decode(asg.pay_basis_id, null, 'Y', 'N') no_paybasis
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