APPS.PQH_CORPS_COPY dependencies on PER_SPINAL_POINT_STEPS_F

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: ;

Line 48: from per_spinal_point_steps_f sps, per_grade_spines_f gsp, per_grades_vl grd

44: l_grade_name varchar2(30);
45: begin
46: select grd.name
47: into l_grade_name
48: from per_spinal_point_steps_f sps, per_grade_spines_f gsp, per_grades_vl grd
49: where sps.grade_spine_id = gsp.grade_spine_id
50: and gsp.grade_id = grd.grade_id
51: and sps.step_id = p_grade_step_id
52: and trunc(sysdate) between sps.effective_start_date and sps.effective_end_date

Line 62: from per_spinal_point_steps_f sps, per_grade_spines_f gsp, per_grades grd

58: l_grade_id number;
59: begin
60: select grd.grade_id
61: into l_grade_id
62: from per_spinal_point_steps_f sps, per_grade_spines_f gsp, per_grades grd
63: where sps.grade_spine_id = gsp.grade_spine_id
64: and gsp.grade_id = grd.grade_id
65: and sps.step_id = p_grade_step_id
66: and trunc(sysdate) between sps.effective_start_date and sps.effective_end_date