DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on FND_USER

Line 339: FROM fnd_user

335: --
336: CURSOR l_starter_user_name_csr( p_starter_user_id NUMBER )
337: IS
338: SELECT user_name
339: FROM fnd_user
340: WHERE user_id = p_starter_user_id;
341: --
342: CURSOR l_starter_full_name_csr(p_starter_user_id NUMBER )
343: IS

Line 345: FROM fnd_user f, per_all_people_f e

341: --
342: CURSOR l_starter_full_name_csr(p_starter_user_id NUMBER )
343: IS
344: SELECT e.first_name||' '||e.last_name
345: FROM fnd_user f, per_all_people_f e
346: WHERE f.user_id = p_starter_user_id
347: AND f.employee_id = e.person_id
348: AND e.effective_start_date = (SELECT MIN(pap.effective_start_date) --Bug 5102146.
349: FROM per_all_people_f pap

Line 1048: FROM fnd_user

1044:
1045: -- Selects modified to Cursors for Bug# 7675780
1046: CURSOR c_employee_id(p_workflow_started_by_id NUMBER) IS
1047: SELECT employee_id
1048: FROM fnd_user
1049: WHERE user_id = p_workflow_started_by_id;
1050:
1051: CURSOR c_supervisor_id(p_employee_id NUMBER) IS
1052: SELECT supervisor_id