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 213: fnd_user fu

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

Line 654: fnd_user fu,

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