DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PER_PERIODS_OF_SERVICE

Line 599: per_periods_of_service serv

595: cursor csr_terminated_date is
596: select serv.actual_termination_date actual_termination_date
597: from
598: per_all_assignments_f asg,
599: per_periods_of_service serv
600: where asg.assignment_id = p_person_rec.assignment_id
601: and asg.period_of_service_id = serv.period_of_service_id
602: and p_effective_date between asg.effective_start_date and asg.effective_end_date
603: and actual_termination_date <= greatest(p_eyu_effective_date,p_effective_date);