DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_SPINAL_POINT_STEPS_F

Line 3714: ,per_spinal_point_steps_f sps

3710: begin
3711: select sps.step_id
3712: into l_ceiling_step_id
3713: from per_spinal_points psp
3714: ,per_spinal_point_steps_f sps
3715: where psp.spinal_point = p_ceiling_point
3716: and psp.spinal_point_id = sps.spinal_point_id
3717: and sps.business_group_id = p_business_group_id
3718: and p_effective_date between

Line 4474: from per_spinal_point_steps_f sps

4470: l_ovn number;
4471: begin
4472: select sps.object_version_number
4473: into l_ovn
4474: from per_spinal_point_steps_f sps
4475: ,per_spinal_points psp
4476: ,per_grade_spines_f pgs
4477: where psp.spinal_point = p_point
4478: and psp.spinal_point_id = sps.spinal_point_id