DBA Data[Home] [Help]

APPS.HR_SPP_WI_DATA dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 203: from per_spinal_point_placements_f

199: -- and sps.spinal_point_id = p_spinal_point_id;
200:
201: select min(effective_start_date)
202: into l_effective_start_date
203: from per_spinal_point_placements_f
204: where placement_id = p_placement_id;
205:
206: if l_effective_start_date = p_effective_date
207: then

Line 239: per_spinal_point_placements_f spp,

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