APPS.PA_TASK_WORKFLOW_PKG dependencies on FND_USER

Line 37: FROM FND_USER

33:
34: -- Cursor to get the user name of the provided user_id
35: CURSOR c_starter_name(l_starter_user_id NUMBER) IS
36: SELECT user_name
37: FROM FND_USER
38: WHERE user_id = l_starter_user_id;
39:
40: -- Cursor to get full name of the user
41: CURSOR c_starter_full_name(l_starter_user_id NUMBER) IS

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 1743: FROM FND_USER

1739: x_msg_data VARCHAR2(4000);
1740:
1741: CURSOR c_starter_name(l_starter_user_id NUMBER) IS
1742: SELECT user_name
1743: FROM FND_USER
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

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