DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on PER_ALL_PEOPLE_F

Line 197: FROM fnd_user f, per_all_people_f e

193:
194: CURSOR l_starter_full_name_csr(l_starter_user_id NUMBER )
195: IS
196: SELECT e.first_name||' '||e.last_name
197: FROM fnd_user f, per_all_people_f e
198: WHERE f.user_id = l_starter_user_id
199: AND f.employee_id = e.person_id
200: and e.effective_end_date = ( SELECT
201: MAX(papf.effective_end_date)

Line 202: FROM per_all_people_f papf

198: WHERE f.user_id = l_starter_user_id
199: AND f.employee_id = e.person_id
200: and e.effective_end_date = ( SELECT
201: MAX(papf.effective_end_date)
202: FROM per_all_people_f papf
203: WHERE papf.person_id = e.person_id);
204:
205: -- 5078716 end
206: