APPS.GHR_PER_SUM dependencies on PER_ALL_ASSIGNMENTS_F
Line 784: select assignment_id from per_all_assignments_f paf
780: ,p_person_id IN NUMBER
781: ,p_assignment_id OUT NOCOPY NUMBER) IS
782:
783: CURSOR cur_emp_assignment IS 784: select assignment_id from per_all_assignments_f paf 785: where paf.person_id = p_person_id
786: and p_effective_date
787: between paf.effective_start_date and paf.effective_end_date;
788: