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.PER_SPINAL_PT_PLCMT_PKG dependencies on PER_SPINAL_POINT_STEPS_F

Line 77: per_spinal_point_steps_f s2,

73: select p1.spinal_point,
74: (nvl(gs.starting_step,1) + count(*))-1 count ,
75: p1.spinal_point_id
76: from per_spinal_points p1,
77: per_spinal_point_steps_f s2,
78: per_spinal_point_steps_f s1,
79: per_grade_spines_f gs
80: where p1.spinal_point_id = s1.spinal_point_id
81: and s1.grade_spine_id = s2.grade_spine_id

Line 78: per_spinal_point_steps_f s1,

74: (nvl(gs.starting_step,1) + count(*))-1 count ,
75: p1.spinal_point_id
76: from per_spinal_points p1,
77: per_spinal_point_steps_f s2,
78: per_spinal_point_steps_f s1,
79: per_grade_spines_f gs
80: where p1.spinal_point_id = s1.spinal_point_id
81: and s1.grade_spine_id = s2.grade_spine_id
82: and s1.grade_spine_id = gs.grade_spine_id

Line 537: per_spinal_point_steps_f sps,

533: from per_grades_vl g,
534: per_grade_spines_f gs,
535: per_parent_spines ps,
536: per_spinal_points sp,
537: per_spinal_point_steps_f sps,
538: per_all_assignments_f asg,
539: ben_pgm_f pgm
540: where asg.assignment_id = p_ass_id
541: and asg.grade_id is not null

Line 558: per_spinal_point_steps_f s2,

554: --
555: cursor c6 is
556: select (nvl(gs.starting_step,1)+count(*))-1
557: from per_spinal_points p2,
558: per_spinal_point_steps_f s2,
559: per_grade_spines_f gs
560: where s2.spinal_point_id = p2.spinal_point_id
561: and p_ceil_seq >= p2.sequence
562: and p_sess between s2.effective_start_date and s2.effective_end_date