APPS.PER_SPP_UPD dependencies on PER_GRADE_SPINES_F

Line 964: from per_grade_spines_f pgs,

960: -- Get the parent_spine_id
961: --
962: select distinct parent_spine_id
963: into l_parent_spine_id
964: from per_grade_spines_f pgs,
965: per_all_assignments_f paa
966: where paa.grade_id = pgs.grade_id
967: and paa.assignment_id = p_assignment_id
968: and p_effective_date between paa.effective_start_date