DBA Data[Home] [Help]

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 936: fnd_user fu -- Bug 6641216

932: select distinct era.wf_role_name
933: from psp_eff_reports er,
934: psp_eff_report_details erd,
935: psp_eff_report_approvals era,
936: fnd_user fu -- Bug 6641216
937: where era.effort_report_detail_id = erd.effort_report_detail_id
938: and erd.effort_report_id = er.effort_report_id
939: and era.approval_status in ( 'A','P')
940: and er.request_id = l_request_id