DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_SPINAL_POINT_STEPS_F

Line 311: , per_spinal_point_steps_f psps

307: select psp.spinal_point spinal_point
308: , count(*) step
309: from per_spinal_points psp
310: , per_spinal_points psp2
311: , per_spinal_point_steps_f psps
312: , per_spinal_point_steps_f psps2
313: where psp.spinal_point_id = psps.spinal_point_id
314: and psps.grade_spine_id = psps2.grade_spine_id
315: and psp2.spinal_point_id = psps2.spinal_point_id

Line 312: , per_spinal_point_steps_f psps2

308: , count(*) step
309: from per_spinal_points psp
310: , per_spinal_points psp2
311: , per_spinal_point_steps_f psps
312: , per_spinal_point_steps_f psps2
313: where psp.spinal_point_id = psps.spinal_point_id
314: and psps.grade_spine_id = psps2.grade_spine_id
315: and psp2.spinal_point_id = psps2.spinal_point_id
316: and psps.step_id=p_special_ceiling_step_id