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_GRADE_SPINES_F

Line 79: per_grade_spines_f gs

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
83: and s1.sequence >= s2.sequence

Line 534: per_grade_spines_f gs,

530: ps.parent_spine_id,
531: sp.sequence,
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,

Line 559: per_grade_spines_f gs

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
563: and p_sess between gs.effective_start_date and gs.effective_end_date