APPS.PER_SPINAL_POINT_STEPS_PKG dependencies on PER_SPINAL_POINT_STEPS_F

Line 478: from per_spinal_point_steps_f sp

474: select 'x'
475: from sys.dual
476: where exists
477: (select null
478: from per_spinal_point_steps_f sp
479: -- per_grade_spines_f gs Bug fix:3648542
480: where sp.grade_spine_id = p_gspine_id
481: and sp.spinal_point_id = p_spoint_id
482: and sp.step_id <> p_step_id);

Line 512: per_spinal_point_steps_f s2

508: cursor c6 is
509: select count(*)
510: from per_spinal_points p1,
511: per_spinal_points p2,
512: per_spinal_point_steps_f s2
513: where s2.spinal_point_id = p2.spinal_point_id
514: and p1.sequence >= p2.sequence
515: and p_sess between
516: s2.effective_start_date and s2.effective_end_date