DBA Data[Home] [Help]

APPS.PER_FASTFORMULA_EVENTS_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 28: from per_all_assignments_f paaf,

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

Line 171: from per_all_assignments_f

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

Line 313: from per_all_assignments_f paaf,

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