APPS.HR_PERSON_TYPE_USAGE_INFO dependencies on PER_PERIODS_OF_PLACEMENT

Line 489: FROM per_periods_of_placement pp

485: ( p_date_start IN DATE
486: ,p_person_id IN NUMBER)
487: IS
488: SELECT pp.period_of_placement_id
489: FROM per_periods_of_placement pp
490: WHERE pp.person_id = p_person_id
491: AND pp.actual_termination_date = p_date_start -1;
492: --
493: CURSOR csr_pos_back_to_back