APPS.HR_PERSON_TYPE_USAGE_INFO dependencies on PER_PERIODS_OF_SERVICE

Line 444: FROM per_periods_of_service ps

440: ( p_date_start IN DATE
441: ,p_person_id IN NUMBER)
442: IS
443: SELECT ps.period_of_service_id
444: FROM per_periods_of_service ps
445: WHERE ps.person_id = p_person_id
446: AND ps.actual_termination_date = p_date_start -1;
447:
448: l_is_back2back_hire NUMBER;

Line 567: FROM per_periods_of_service ps

563: ( p_date_start IN DATE
564: ,p_person_id IN NUMBER)
565: IS
566: SELECT ps.period_of_service_id
567: FROM per_periods_of_service ps
568: WHERE ps.person_id = p_person_id
569: AND ps.actual_termination_date = p_date_start -1;
570: --
571: