DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on FND_USER

Line 50: FROM fnd_user

46: l_employee_id NUMBER;
47: --
48: CURSOR l_employee_csr IS
49: SELECT employee_id
50: FROM fnd_user
51: WHERE user_id = p_workflow_started_by_id;
52:
53: CURSOR l_approver_csr IS
54: SELECT supervisor_id

Line 178: FROM fnd_user

174: --
175: CURSOR l_starter_name_csr( l_starter_user_id NUMBER )
176: IS
177: SELECT user_name
178: FROM fnd_user
179: WHERE user_id = l_starter_user_id;
180:
181: -- 5078716 For R12 Performance Fix, changed cursor select query
182: -- Removed pa_employee view usage with base tables , the query

Line 189: FROM fnd_user f, pa_employees e

185: /*
186: CURSOR l_starter_full_name_csr(l_starter_user_id NUMBER )
187: IS
188: SELECT e.first_name||' '||e.last_name
189: FROM fnd_user f, pa_employees e
190: WHERE f.user_id = l_starter_user_id
191: AND f.employee_id = e.person_id;
192: */
193:

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)