[Home] [Help]
23: SELECT f.user_id user_id
24: ,f.user_name user_name
25: ,e.first_name||' '||e.last_name full_name
26: FROM FND_USER f
27: ,PA_EMPLOYEES e
28: WHERE f.employee_id = p_manager_id
29: AND f.employee_id = e.person_id;
30:
31: CURSOR c_proj_manager (l_project_id NUMBER) IS