DBA Data[Home] [Help]

APPS.PQH_CORPS_COPY dependencies on PER_GRADES_VL

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