APPS.PQH_CORPS_UTILITY dependencies on PER_SPINAL_POINTS

Line 12: per_spinal_points point

8: point.spinal_point,
9: steps.spinal_point_id,
10: steps.grade_spine_id
11: FROM per_spinal_point_steps_f steps,
12: per_spinal_points point
13: WHERE steps.step_id = p_step_id
14: AND steps.spinal_point_id = point.spinal_point_id
15: AND p_eff_date BETWEEN steps.effective_start_date AND steps.effective_end_date;
16:

Line 264: per_spinal_points point

260: steps.grade_spine_id,
261: point.information1 "IB",
262: get_increased_index(point.information1,p_effective_date) "INM"
263: FROM per_spinal_point_steps_f steps,
264: per_spinal_points point
265: WHERE steps.step_id = p_step_id
266: AND steps.spinal_point_id = point.spinal_point_id
267: AND p_effective_date BETWEEN steps.effective_start_date AND steps.effective_end_date;
268:

Line 381: per_spinal_points psp

377: SELECT 'Y'
378: FROM dual
379: WHERE EXISTS (SELECT '1'
380: FROM per_parent_spines pps,
381: per_spinal_points psp
382: WHERE psp.information1 = p_gross_index
383: AND psp.information_category = 'FR_PQH'
384: AND psp.parent_spine_id = pps.parent_spine_id
385: AND pps.information_category = 'FR_PQH'

Line 726: per_spinal_points psp

722: IS
723: SELECT psp.information1
724: FROM per_spinal_point_placements_f spp,
725: per_spinal_point_steps_f sps,
726: per_spinal_points psp
727: WHERE spp.step_id = p_step_id
728: AND p_effective_date BETWEEN spp.effective_start_date
729: AND spp.effective_end_date
730: AND spp.step_id = sps.step_id