APPS.HR_EX_EMPLOYEE_API dependencies on PER_TIME_PERIODS

Line 756: from per_time_periods tpe

752: and pet.person_type_id = per.person_type_id;
753: --
754: cursor csr_get_max_tpe_end_date is
755: select max(tpe.end_date)
756: from per_time_periods tpe
757: ,per_assignments_f asg
758: where asg.period_of_service_id = p_period_of_service_id
759: and l_actual_termination_date between asg.effective_start_date
760: and asg.effective_end_date