DBA Data[Home] [Help]

APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PA_EMPLOYEES

Line 27: ,PA_EMPLOYEES e

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