eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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);
142: l_sequence_number number;
143: l_parent_spine_id number;
144: l_special_ceiling_step_id number;

Line 234: from per_grades_vl pg,

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