DBA Data[Home] [Help]

APPS.PQH_CPD_BUS dependencies on PER_SPINAL_POINT_STEPS_F

Line 636: per_spinal_point_steps_f sps

632: p_effective_date DATE) IS
633: CURSOR csr_valid_step IS
634: SELECT 'Y'
635: FROM per_grade_spines_f gs,
636: per_spinal_point_steps_f sps
637: WHERE gs.grade_id = p_starting_grade_id
638: AND p_effective_date BETWEEN gs.effective_start_date and gs.effective_end_date
639: AND gs.grade_spine_id = sps.grade_spine_id
640: AND sps.step_id = p_starting_grade_step_id