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_GRADE_SPINES_F

Line 236: per_grade_spines_f pgs

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
239: and sps.step_id = p_step_id
240: and p_effective_date between sps.effective_start_date

Line 270: from per_grade_spines_f pgs,

266: --
267: select distinct pgs.ceiling_step_id,
268: nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)
269: into l_ceiling_step_id, l_special_ceiling_step_id
270: from per_grade_spines_f pgs,
271: per_spinal_point_steps_f sps,
272: per_spinal_point_placements_f spp,
273: per_all_assignments_f paa
274: where pgs.grade_spine_id = sps.grade_spine_id