431: ( p_date_start IN DATE
432: ,p_person_id IN NUMBER)
433: IS
434: SELECT pp.period_of_placement_id
435: FROM per_periods_of_placement pp
436: WHERE pp.person_id = p_person_id
437: AND pp.actual_termination_date = p_date_start -1;
438: --
439: CURSOR csr_pos_back_to_back
554: ( p_date_start IN DATE
555: ,p_person_id IN NUMBER)
556: IS
557: SELECT pp.period_of_placement_id
558: FROM per_periods_of_placement pp
559: WHERE pp.person_id = p_person_id
560: AND pp.actual_termination_date = p_date_start -1;
561: --
562: CURSOR csr_pos_back_to_back