Line 2945: from per_all_assignments_f asg, per_all_people_f per
2941: from per_all_people_f per, fnd_user usr
2942: where per.person_id = usr.employee_id
2943: and usr.user_id = p_user_id;
2944: cursor c2 is select full_name 2945: from per_all_assignments_f asg, per_all_people_f per 2946: where asg.person_id = per.person_id
2947: and sysdate between asg.effective_start_date and asg.effective_end_date
2948: and sysdate between per.effective_start_date and per.effective_end_date
2949: and asg.assignment_id = p_assignment_id ;