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.

[Home] [Help]

APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_GRADE_SPINES_F

Line 238: per_grade_spines_f pgs

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

Line 272: from per_grade_spines_f pgs,

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