APPS.PQH_CORPS_COPY dependencies on PER_SPINAL_POINTS

Line 36: from per_spinal_point_steps_f sps, per_spinal_points spt

32: l_step_name varchar2(30);
33: begin
34: select spt.spinal_point step_name
35: into l_step_name
36: from per_spinal_point_steps_f sps, per_spinal_points spt
37: where sps.spinal_point_id = spt.spinal_point_id
38: and sps.step_id = p_grade_step_id
39: and trunc(sysdate) between sps.effective_start_date and sps.effective_end_date
40: ;