APPS.PSP_ER_WORKFLOW dependencies on FND_USER

Line 565: l_user_id fnd_user.user_id%type;

561:
562: l_approver_order_num integer;
563: l_role_name varchar2(320);
564: l_role_display_name varchar2(360);
565: l_user_id fnd_user.user_id%type;
566: l_login_id number;
567:
568: cursor role_name_cur is
569: select wf_role_name

Line 920: fnd_user fu -- Bug 6641216

916: select distinct era.wf_role_name
917: from psp_eff_reports er,
918: psp_eff_report_details erd,
919: psp_eff_report_approvals era,
920: fnd_user fu -- Bug 6641216
921: where era.effort_report_detail_id = erd.effort_report_detail_id
922: and erd.effort_report_id = er.effort_report_id
923: and era.approval_status in ( 'A','P')
924: and er.request_id = l_request_id