215: l_manager_employee_id NUMBER;
216:
217: CURSOR mgr IS
218: SELECT supervisor_id
219: FROM per_all_assignments_f
220: WHERE person_id = l_employee_id
221: AND per_all_assignments_f.primary_flag = 'Y'
222: AND per_all_assignments_f.assignment_type in ('E','C')
223: AND per_all_assignments_f.assignment_status_type_id
217: CURSOR mgr IS
218: SELECT supervisor_id
219: FROM per_all_assignments_f
220: WHERE person_id = l_employee_id
221: AND per_all_assignments_f.primary_flag = 'Y'
222: AND per_all_assignments_f.assignment_type in ('E','C')
223: AND per_all_assignments_f.assignment_status_type_id
224: NOT IN
225: (SELECT assignment_status_type_id
218: SELECT supervisor_id
219: FROM per_all_assignments_f
220: WHERE person_id = l_employee_id
221: AND per_all_assignments_f.primary_flag = 'Y'
222: AND per_all_assignments_f.assignment_type in ('E','C')
223: AND per_all_assignments_f.assignment_status_type_id
224: NOT IN
225: (SELECT assignment_status_type_id
226: FROM per_assignment_status_types
219: FROM per_all_assignments_f
220: WHERE person_id = l_employee_id
221: AND per_all_assignments_f.primary_flag = 'Y'
222: AND per_all_assignments_f.assignment_type in ('E','C')
223: AND per_all_assignments_f.assignment_status_type_id
224: NOT IN
225: (SELECT assignment_status_type_id
226: FROM per_assignment_status_types
227: WHERE per_system_status = 'TERM_ASSIGN');
2814:
2815:
2816: CURSOR manager (p_employee_id NUMBER) IS
2817: SELECT supervisor_id
2818: FROM per_all_assignments_f
2819: WHERE person_id = p_employee_id
2820: AND primary_flag = 'Y' -- get primary assgt
2821: AND assignment_type = 'E' -- ensure emp assgt, not applicant assgt
2822: AND trunc(sysdate) BETWEEN effective_start_date