APPS.AP_WEB_EXPENSE_WF dependencies on FND_USER

Line 10525: SELECT user_id INTO l_temp_entered_by FROM fnd_user WHERE user_name = l_temp_user_name;

10521: SELECT NVL(MORE_INFO_ROLE, RECIPIENT_ROLE) INTO l_temp_user_name
10522: FROM wf_notifications
10523: WHERE notification_id = l_notificationID;
10524:
10525: SELECT user_id INTO l_temp_entered_by FROM fnd_user WHERE user_name = l_temp_user_name;
10526: l_entered_by := l_temp_entered_by;
10527: EXCEPTION
10528: WHEN OTHERS THEN
10529: NULL;

Line 14731: l_auditor_name fnd_user.user_name%type;

14727: p_funmode IN VARCHAR2,
14728: p_result OUT NOCOPY VARCHAR2) IS
14729: ----------------------------------------------------------------------
14730: l_debug_info VARCHAR2(200);
14731: l_auditor_name fnd_user.user_name%type;
14732: BEGIN
14733:
14734: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetFromRoleAP');
14735:

Line 14743: FROM fnd_user

14739: ----------------------------------------------------------------
14740: -- Setting the from role to the last auditor Bug 8371199 (sodash)
14741: begin
14742: SELECT user_name INTO l_auditor_name
14743: FROM fnd_user
14744: WHERE user_id=(SELECT last_audited_by
14745: FROM ap_expense_report_headers_all
14746: WHERE report_header_id=p_item_key);
14747: exception

Line 15232: l_user_name fnd_user.user_name%TYPE := null;

15228: l_new_language_code ap_expense_params.note_language_code%type := null;
15229: l_new_language fnd_languages.nls_language%type := null;
15230:
15231: l_entered_by NUMBER := fnd_global.user_id;
15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';
15234:
15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;
15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;

Line 15981: fnd_user fnd

15977: l_approver_id,
15978: l_week_end_date,
15979: l_workflow_flag
15980: from ap_expense_report_headers aerh,
15981: fnd_user fnd
15982: where aerh.report_header_id = l_report_header_id
15983: and fnd.user_id = aerh.created_by;
15984:
15985: select sum(aerl.amount),

Line 15983: and fnd.user_id = aerh.created_by;

15979: l_workflow_flag
15980: from ap_expense_report_headers aerh,
15981: fnd_user fnd
15982: where aerh.report_header_id = l_report_header_id
15983: and fnd.user_id = aerh.created_by;
15984:
15985: select sum(aerl.amount),
15986: sum(decode(sign(aerl.amount),-1,0,aerl.amount))
15987: into l_total,