DBA Data[Home] [Help]

APPS.PER_GB_REVERSE_TERM_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 18: FROM per_all_assignments_f paaf,

14: --
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