DBA Data[Home] [Help]

APPS.HR_PERSON_TYPE_USAGE_INFO dependencies on PER_PERIODS_OF_PLACEMENT

Line 435: FROM per_periods_of_placement pp

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

Line 558: FROM per_periods_of_placement pp

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