1312: cp_effective_date in date) is
1313: select count(*)
1314: from per_spinal_points psp,
1315: per_spinal_points psp2,
1316: per_spinal_point_steps_f psps,
1317: per_spinal_point_steps_f psps2
1318: where psps.step_id = cp_sp_ceil_step_id
1319: and psp.spinal_point_id = psps.spinal_point_id
1320: and psps.grade_spine_id = psps2.grade_spine_id
1313: select count(*)
1314: from per_spinal_points psp,
1315: per_spinal_points psp2,
1316: per_spinal_point_steps_f psps,
1317: per_spinal_point_steps_f psps2
1318: where psps.step_id = cp_sp_ceil_step_id
1319: and psp.spinal_point_id = psps.spinal_point_id
1320: and psps.grade_spine_id = psps2.grade_spine_id
1321: and psp2.spinal_point_id = psps2.spinal_point_id