808: --
809: CURSOR lc_hire_date
810: IS
811: SELECT MIN(pps.date_start)
812: FROM per_periods_of_service pps,
813: per_all_assignments_f asg
814: WHERE asg.assignment_id = p_assignment_id
815: AND asg.person_id = pps.person_id;
816:
831: --AND per_system_status = 'TERM_ASSIGN';
832:
833: CURSOR lc_termination_date IS
834: select ser.actual_termination_date
835: from per_periods_of_service ser,
836: per_all_assignments_f ass
837: where ass.period_of_service_id = ser.period_of_service_id
838: AND TRUNC(SYSDATE) between ass.effective_start_date
839: AND ass.effective_end_date