611: CURSOR assign_num_cur IS
612: SELECT paf.assignment_number,
613: ppf.employee_number
614: FROM
615: per_assignments_f paf,per_people_f ppf
616: WHERE paf.assignment_id =p_assignment_id
617: AND paf.person_id =ppf.person_id
618: AND p_effective_date between paf.effective_start_date and paf.effective_end_date
619: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;