APPS.GHR_PER_SUM dependencies on PER_ALL_ASSIGNMENTS_F

Line 775: select assignment_id from per_all_assignments_f paf

771: ,p_person_id IN NUMBER
772: ,p_assignment_id OUT NOCOPY NUMBER) IS
773:
774: CURSOR cur_emp_assignment IS
775: select assignment_id from per_all_assignments_f paf
776: where paf.person_id = p_person_id
777: and p_effective_date
778: between paf.effective_start_date and paf.effective_end_date;
779: