24: --
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
167: --
168: cursor csr_get_emp_asgs_snapshot is
169: select effective_start_date,
170: assignment_id
171: from per_all_assignments_f
172: where person_id = p_person_id
173: and assignment_type = 'E'
174: and p_effective_date
175: between effective_start_date
309: --
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