DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_API dependencies on PER_TIME_PERIODS

Line 698: from per_time_periods tpe

694: and pet.person_type_id = per.person_type_id;
695: --
696: cursor csr_get_max_tpe_end_date is
697: select max(tpe.end_date)
698: from per_time_periods tpe
699: ,per_assignments_f asg
700: where asg.period_of_service_id = p_period_of_service_id
701: and l_actual_termination_date between asg.effective_start_date
702: and asg.effective_end_date