APPS.HR_SPP_WI_DATA dependencies on PER_SPINAL_POINT_STEPS_F

Line 190: per_spinal_point_steps_f sps,

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
194: and sps.step_id = p_step_id

Line 214: per_spinal_point_steps_f sps

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
218: and sps.effective_end_date;

Line 240: per_spinal_point_steps_f sps1,

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
243: and psp2.spinal_point_id = sps2.spinal_point_id
244: and sps2.step_id = p_step_id

Line 241: per_spinal_point_steps_f sps2

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
243: and psp2.spinal_point_id = sps2.spinal_point_id
244: and sps2.step_id = p_step_id
245: and sps1.step_id = spp.step_id