APPS.HR_SPP_WI_DATA dependencies on PER_GRADES

Line 145: l_grade_name per_grades.name%TYPE;

141: l_old_spinal_point varchar2(30);
142: l_new_spinal_point varchar2(30);
143: l_old_value number;
144: l_new_value number;
145: l_grade_name per_grades.name%TYPE;
146: l_old_spinal_point_id number;
147: l_new_spinal_point_id number;
148: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
149: l_effective_start_date date;

Line 189: from per_grades_vl pg,

185: --
186: hr_utility.set_location('grade name',122);
187: select substr(pg.name,1,30)
188: into l_grade_name
189: from per_grades_vl pg,
190: per_spinal_point_steps_f sps,
191: per_grade_spines_f pgs
192: where pg.grade_id = pgs.grade_id
193: and pgs.grade_spine_id = sps.grade_spine_id