eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_CORPS_UTILITY dependencies on PER_SPINAL_POINT_STEPS_F

Line 11: FROM per_spinal_point_steps_f steps,

7: SELECT --steps.sequence||'('|| point.spinal_point||')' "SEQUENCE",
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;

Line 263: FROM per_spinal_point_steps_f steps,

259: steps.spinal_point_id,
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;

Line 725: per_spinal_point_steps_f sps,

721: CURSOR csr_gross_index
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