APPS.PA_TASKS_MAINT_UTILS dependencies on PA_EMPLOYEES

Line 26: from pa_employees

22: l_id_found_flag VARCHAR2(1) := 'N';
23:
24: cursor c IS
25: select person_id
26: from pa_employees
27: where upper(full_name) = upper(p_task_mgr_name)
28: and active = '*'; --for bug 3245820
29:
30: cursor c1 IS

Line 32: from pa_employees

28: and active = '*'; --for bug 3245820
29:
30: cursor c1 IS
31: select person_id
32: from pa_employees
33: where upper(full_name) = upper(p_task_mgr_name)
34: and active = '*' -- for bug 3245820
35: and person_id in
36: ( select RESOURCE_source_ID

Line 49: --select from pa_employees

45: -- ID is empty
46: IF (p_task_mgr_name IS NOT NULL AND p_task_mgr_name<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
47: --Added for task manager changes;
48: IF (PA_TASKS_MAINT_UTILS.GET_TASK_MANAGER_PROFILE = 'N') THEN
49: --select from pa_employees
50: OPEN c;
51: LOOP
52: FETCH c INTO l_current_id;
53: EXIT when c%NOTFOUND;

Line 89: --select from pa_employees

85: -- ID is not empty;
86: IF (p_check_id_flag = 'Y') THEN
87: --Added for task manager changes;
88: IF (PA_TASKS_MAINT_UTILS.GET_TASK_MANAGER_PROFILE = 'N') THEN
89: --select from pa_employees
90: SELECT person_id
91: INTO x_task_mgr_id
92: FROM pa_employees
93: WHERE person_id = p_task_mgr_id;

Line 92: FROM pa_employees

88: IF (PA_TASKS_MAINT_UTILS.GET_TASK_MANAGER_PROFILE = 'N') THEN
89: --select from pa_employees
90: SELECT person_id
91: INTO x_task_mgr_id
92: FROM pa_employees
93: WHERE person_id = p_task_mgr_id;
94: ELSE
95: --select from team members
96: SELECT person_id

Line 98: FROM pa_employees

94: ELSE
95: --select from team members
96: SELECT person_id
97: INTO x_task_mgr_id
98: FROM pa_employees
99: WHERE person_id = p_task_mgr_id
100: AND person_id in
101: ( select RESOURCE_source_ID
102: from pa_project_parties ppp

Line 113: --select from pa_employees

109: x_task_mgr_id := p_task_mgr_id;
110: ELSIF (p_check_id_flag = 'A') THEN
111: --Added for task manager changes;
112: IF (PA_TASKS_MAINT_UTILS.GET_TASK_MANAGER_PROFILE = 'N') THEN
113: --select from pa_employees
114: OPEN c;
115: LOOP
116: FETCH c INTO l_current_id;
117: EXIT when c%NOTFOUND;