APPS.HR_CONTINGENT_WORKER_API dependencies on PER_TIME_PERIODS

Line 1783: from per_time_periods tpe

1779: and per.effective_end_date;
1780: --
1781: cursor csr_get_max_tpe_end_date is
1782: select max(tpe.end_date)
1783: from per_time_periods tpe
1784: ,per_all_assignments_f asg
1785: where asg.person_id = l_person_id
1786: and asg.period_of_placement_date_start = l_date_start
1787: and l_actual_termination_date between asg.effective_start_date