25: cursor csr_get_emp_asgs is
26: select paaf.effective_start_date,
27: paaf.assignment_id
28: from per_all_assignments_f paaf,
29: per_assignment_status_types past
30: where paaf.person_id = p_person_id
31: and paaf.assignment_type = 'E'
32: -- bug 2975652 only want to count active assignments
33: and paaf.assignment_status_type_id = past.assignment_status_type_id
310: cursor csr_get_emp_asgs is
311: select paaf.effective_start_date,
312: paaf.assignment_id
313: from per_all_assignments_f paaf,
314: per_assignment_status_types past
315: where paaf.person_id = p_person_id
316: and paaf.assignment_type = 'E'
317: -- bug 2975652 only want to count active assignments
318: and paaf.assignment_status_type_id = past.assignment_status_type_id