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 1025: FROM fnd_user

1021: -- Specify Your Business Rules Here
1022:
1023: SELECT employee_id
1024: INTO l_employee_id
1025: FROM fnd_user
1026: WHERE user_id = p_workflow_started_by_id;
1027:
1028: SELECT supervisor_id
1029: INTO p_budget_baseliner_id