APPS.PA_DCTN_APRV_NOTIFICATION dependencies on FND_USER

Line 17: FROM FND_USER

13: ) IS
14:
15: CURSOR c_starter_name(l_starter_user_id NUMBER) IS
16: SELECT user_name
17: FROM FND_USER
18: WHERE user_id = l_starter_user_id;
19:
20: CURSOR c_starter_full_name(l_starter_user_id NUMBER) IS
21: SELECT e.first_name||' '||e.last_name

Line 22: FROM FND_USER f, PER_ALL_PEOPLE_F e

18: WHERE user_id = l_starter_user_id;
19:
20: CURSOR c_starter_full_name(l_starter_user_id NUMBER) IS
21: SELECT e.first_name||' '||e.last_name
22: FROM FND_USER f, PER_ALL_PEOPLE_F e
23: WHERE f.user_id = l_starter_user_id
24: AND f.employee_id = e.person_id
25: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
26: FROM per_all_people_f papf