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_POINTS

Line 76: from per_spinal_points p1,

72: cursor c2 is
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

Line 536: per_spinal_points sp,

532: pgm.name
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

Line 557: from per_spinal_points p2,

553: and asg.business_group_id + 0 = p_bgroup_id;
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