57: CURSOR csr_rehire_date (p_asg_id NUMBER,
58: p_end_date DATE,
59: p_start_date DATE) IS
60: SELECT MAX(service.date_start) hire_date
61: FROM per_periods_of_service service,
62: per_assignments_f asg
63: WHERE asg.assignment_id = p_asg_id
64: AND p_end_date BETWEEN
65: asg.effective_start_date
1230: l_start_date1 DATE;
1231:
1232: cursor cur_date_of_hire is
1233: select max(service.date_start) hire_date
1234: from per_periods_of_service service,
1235: per_assignments_f asg
1236: where asg.assignment_id = p_assignment_id
1237: and p_end_date BETWEEN
1238: asg.effective_start_date