DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_EMPLOYEES

Line 96: ,pa_employees e

92: SELECT f.user_id user_id
93: ,f.user_name user_name
94: ,e.first_name||' '||e.last_name full_name
95: FROM fnd_user f
96: ,pa_employees e
97: WHERE f.employee_id = p_manager_id
98: AND f.employee_id = e.person_id;
99:
100: Cursor c_proj_manager (l_project_id NUMBER)