APPS.PA_TASK_WORKFLOW_PKG dependencies on PER_ALL_PEOPLE_F

Line 43: FROM FND_USER f, PER_ALL_PEOPLE_F e

39:
40: -- Cursor to get full name of the user
41: CURSOR c_starter_full_name(l_starter_user_id NUMBER) IS
42: SELECT e.first_name||' '||e.last_name
43: FROM FND_USER f, PER_ALL_PEOPLE_F e
44: WHERE f.user_id = l_starter_user_id
45: AND f.employee_id = e.person_id
46: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
47: FROM per_all_people_f papf

Line 47: FROM per_all_people_f papf

43: FROM FND_USER f, PER_ALL_PEOPLE_F e
44: WHERE f.user_id = l_starter_user_id
45: AND f.employee_id = e.person_id
46: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
47: FROM per_all_people_f papf
48: WHERE papf.person_id = e.person_id);
49: CURSOR c_wf_started_date IS
50: SELECT SYSDATE FROM SYS.DUAL;
51:

Line 1748: FROM FND_USER f, PER_ALL_PEOPLE_F e

1744: WHERE user_id = l_starter_user_id;
1745:
1746: CURSOR c_starter_full_name(l_starter_user_id NUMBER) IS
1747: SELECT e.first_name||' '||e.last_name
1748: FROM FND_USER f, PER_ALL_PEOPLE_F e
1749: WHERE f.user_id = l_starter_user_id
1750: AND f.employee_id = e.person_id
1751: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
1752: FROM per_all_people_f papf

Line 1752: FROM per_all_people_f papf

1748: FROM FND_USER f, PER_ALL_PEOPLE_F e
1749: WHERE f.user_id = l_starter_user_id
1750: AND f.employee_id = e.person_id
1751: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
1752: FROM per_all_people_f papf
1753: WHERE papf.person_id = e.person_id);
1754: c_task_info_rec c_task_info%ROWTYPE;
1755: BEGIN
1756: