DBA Data[Home] [Help]

APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

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

Line 26: FROM per_all_people_f papf

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
27: WHERE papf.person_id = e.person_id);
28: CURSOR c_wf_started_date IS
29: SELECT SYSDATE FROM SYS.DUAL;
30: