APPS.PER_SPP_UPD dependencies on PER_ALL_ASSIGNMENTS_F

Line 918: per_all_assignments_f paa

914: --
915: select distinct parent_spine_id
916: into l_parent_spine_id
917: from per_grade_spines_f pgs,
918: per_all_assignments_f paa
919: where paa.grade_id = pgs.grade_id
920: and paa.assignment_id = p_assignment_id
921: and p_effective_date between paa.effective_start_date
922: and paa.effective_end_date