DBA Data[Home] [Help]

APPS.PER_FASTFORMULA_EVENTS_UTILITY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 29: per_assignment_status_types past

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

Line 314: per_assignment_status_types past

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