DBA Data[Home] [Help]

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: