DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_SPINAL_POINT_STEPS_F

Line 3741: ,per_spinal_point_steps_f sps

3737: begin
3738: select sps.step_id
3739: into l_ceiling_step_id
3740: from per_spinal_points psp
3741: ,per_spinal_point_steps_f sps
3742: where psp.spinal_point = p_ceiling_point
3743: and psp.spinal_point_id = sps.spinal_point_id
3744: and sps.business_group_id = p_business_group_id
3745: and p_effective_date between

Line 4501: from per_spinal_point_steps_f sps

4497: l_ovn number;
4498: begin
4499: select sps.object_version_number
4500: into l_ovn
4501: from per_spinal_point_steps_f sps
4502: ,per_spinal_points psp
4503: ,per_grade_spines_f pgs
4504: where psp.spinal_point = p_point
4505: and psp.spinal_point_id = sps.spinal_point_id