APPS.PER_GB_REVERSE_TERM_RULES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 19: per_assignment_status_types past

15: cursor csr_all_assignments is
16: SELECT paaf.assignment_id,
17: paaf.assignment_number
18: FROM per_all_assignments_f paaf,
19: per_assignment_status_types past
20: WHERE paaf.person_id = p_person_id
21: and p_actual_termination_date between paaf.effective_start_date and paaf.effective_end_date
22: AND paaf.assignment_status_type_id = past.assignment_status_type_id
23: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN');