DBA Data[Home] [Help]

APPS.PER_SPP_UPD dependencies on PER_ALL_ASSIGNMENTS_F

Line 965: per_all_assignments_f paa

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
969: and paa.effective_end_date