APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_GRADES

Line 140: l_grade_name per_grades.name%TYPE;

136: ,p_update varchar2
137: ) is
138:
139: l_pay_scale varchar2(30);
140: l_grade_name per_grades.name%TYPE;
141: -- l_full_name varchar2(60); Fix for bug 16090637
142: l_full_name varchar2(240);
143: l_sequence_number number;
144: l_parent_spine_id number;

Line 236: from per_grades_vl pg,

232: --
233: hr_utility.set_location('grade name',122);
234: select substr(pg.name,1,30),pgs.grade_spine_id
235: into l_grade_name,l_grade_spine_id
236: from per_grades_vl pg,
237: per_spinal_point_steps_f sps,
238: per_grade_spines_f pgs
239: where pg.grade_id = pgs.grade_id
240: and pgs.grade_spine_id = sps.grade_spine_id