[Home] [Help]
2551: -- view.
2552: --
2553: SELECT paf.assignment_id
2554: INTO l_assignment_id
2555: FROM per_assignments_f2 paf
2556: WHERE paf.person_id = p_person_id
2557: AND p_effective_date BETWEEN
2558: paf.effective_start_date AND paf.effective_end_date
2559: AND paf.assignment_type = p_assignment_type