APPS.HR_PERSON_TYPE_USAGE_INFO dependencies on PER_PERIODS_OF_SERVICE

Line 498: FROM per_periods_of_service ps

494: ( p_date_start IN DATE
495: ,p_person_id IN NUMBER)
496: IS
497: SELECT ps.period_of_service_id
498: FROM per_periods_of_service ps
499: WHERE ps.person_id = p_person_id
500: AND ps.actual_termination_date = p_date_start -1;
501: --
502: