[Home] [Help]
2152: and per.effective_end_date;
2153: --
2154: cursor csr_get_max_tpe_end_date is
2155: select max(tpe.end_date)
2156: from per_time_periods tpe
2157: ,per_all_assignments_f asg
2158: where asg.person_id = l_person_id
2159: and asg.period_of_placement_date_start = l_date_start
2160: and l_actual_termination_date between asg.effective_start_date