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_WI_DATA dependencies on PER_SPINAL_POINTS

Line 213: from per_spinal_points psp,

209: select substr(psp.spinal_point,1,30),
210: psp.spinal_point_id
211: into l_new_spinal_point,
212: l_new_spinal_point_id
213: from per_spinal_points psp,
214: per_spinal_point_steps_f sps
215: where psp.spinal_point_id = sps.spinal_point_id
216: and sps.step_id = p_step_id
217: and p_effective_date between sps.effective_start_date

Line 237: from per_spinal_points psp1,

233: into l_old_spinal_point,
234: l_new_spinal_point,
235: l_old_spinal_point_id,
236: l_new_spinal_point_id
237: from per_spinal_points psp1,
238: per_spinal_points psp2,
239: per_spinal_point_placements_f spp,
240: per_spinal_point_steps_f sps1,
241: per_spinal_point_steps_f sps2

Line 238: per_spinal_points psp2,

234: l_new_spinal_point,
235: l_old_spinal_point_id,
236: l_new_spinal_point_id
237: from per_spinal_points psp1,
238: per_spinal_points psp2,
239: per_spinal_point_placements_f spp,
240: per_spinal_point_steps_f sps1,
241: per_spinal_point_steps_f sps2
242: where psp1.spinal_point_id = sps1.spinal_point_id