APPS.PSP_XMLGEN dependencies on FND_USER

Line 30: FROM fnd_user fu,

26: AND pdf_request_id = g_request_id;
27:
28: CURSOR user_name_cur IS
29: SELECT user_name
30: FROM fnd_user fu,
31: fnd_concurrent_requests fcr
32: WHERE fu.user_id = fcr.requested_by
33: AND fcr.request_id = p_request_id;
34:

Line 35: l_user_name fnd_user.user_name%TYPE;

31: fnd_concurrent_requests fcr
32: WHERE fu.user_id = fcr.requested_by
33: AND fcr.request_id = p_request_id;
34:
35: l_user_name fnd_user.user_name%TYPE;
36: l_error_count NUMBER;
37: l_return_status CHAR(1);
38: l_language_code VARCHAR2(30);
39: BEGIN

Line 211: fnd_user fu

207: haou.name
208: FROM hr_all_organization_units haou,
209: psp_eff_report_approvals pera,
210: per_all_assignments_f paaf,
211: fnd_user fu
212: WHERE pera.wf_item_key = p_wf_item_key
213: AND fu.employee_id = paaf.person_id
214: AND fu.user_name = pera.wf_role_name
215: AND paaf.primary_flag = 'Y'

Line 650: fnd_user fu,

646: /* Added for TGEN Bug 6864426 for pre-approved effort report*/
647: CURSOR initiator_name_cur IS
648: SELECT ppf.full_name
649: FROM per_people_f ppf,
650: fnd_user fu,
651: fnd_concurrent_requests fcr
652: WHERE fu.user_id = fcr.requested_by
653: AND fu.employee_id = ppf.person_id
654: AND fcr.request_id = p_request_id;