[Home] [Help]
16929: ,p_spinal_point_id IN NUMBER
16930: ) IS
16931: SELECT pspp.placement_id
16932: FROM per_spinal_point_placements_f pspp
16933: ,per_grade_spines_f pgs
16934: ,per_spinal_point_steps_f psps
16935: WHERE pspp.assignment_id = p_assignment_id
16936: AND p_effective_date BETWEEN pspp.effective_start_date
16937: AND pspp.effective_end_date