DBA Data[Home] [Help]

APPS.PA_DCTN_APRV_NOTIFICATION dependencies on FND_USER

Line 26: FROM FND_USER f

22: CURSOR c_manager( p_manager_id NUMBER ) IS
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: