APPS.PA_PWP_NOTIFICATION dependencies on FND_USER

Line 138: FROM fnd_user

134:
135: CURSOR c_starter_name( l_starter_user_id NUMBER )
136: IS
137: SELECT user_name
138: FROM fnd_user
139: WHERE user_id = l_starter_user_id;
140:
141: CURSOR c_starter_full_name(l_starter_user_id NUMBER )
142: IS

Line 144: FROM fnd_user f, per_all_people_f e

140:
141: CURSOR c_starter_full_name(l_starter_user_id NUMBER )
142: IS
143: SELECT e.first_name||' '||e.last_name
144: FROM fnd_user f, per_all_people_f e
145: WHERE f.user_id = l_starter_user_id
146: AND f.employee_id = e.person_id
147: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
148: FROM per_all_people_f papf