1748: and approved = 'Y');
1749:
1750: Cursor C_step is
1751: Select step_id
1752: from Per_spinal_pt_placements_v
1753: where assignment_id = l_assignment_id;
1754:
1755: Cursor C_grade_spine is
1756: SELECT pss.grade_spine_id,pss.spinal_point_id,
1754:
1755: Cursor C_grade_spine is
1756: SELECT pss.grade_spine_id,pss.spinal_point_id,
1757: pss.sequence
1758: FROM per_spinal_pt_placements_v psp, per_spinal_point_steps pss
1759: WHERE psp.step_id = pss.step_id
1760: AND psp.assignment_id = l_assignment_id;
1761:
1762: Cursor C_session is