APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on FND_USER

Line 128: FROM fnd_user u,

124:
125: -- is p_auditor_id the creator or employee for p_report_header_id; if yes then we should
126: -- return with INVALID_ASSIGNMENT; else proceed normally.
127: SELECT count(1) INTO l_scratch
128: FROM fnd_user u,
129: ap_expense_report_headers_all exp
130: WHERE u.user_id <> -1
131: AND u.user_id = p_auditor_id
132: -- making sure auditor does not audit expense report owned by her OR filed by her

Line 411: fnd_user u,

407: SELECT a.auditor_id
408: FROM ap_aud_auditors a,
409: per_organization_list per,
410: hr_organization_information oi,
411: fnd_user u,
412: ap_expense_report_headers_all exp
413: WHERE a.security_profile_id = per.security_profile_id
414: AND a.auditor_id <> -1
415: AND per.organization_id = oi.organization_id

Line 429: fnd_user u,

425: UNION
426: SELECT a.auditor_id
427: FROM ap_aud_auditors a,
428: per_security_profiles sec,
429: fnd_user u,
430: ap_expense_report_headers_all exp
431: WHERE a.security_profile_id = sec.security_profile_id
432: AND sec.view_all_organizations_flag = 'Y'
433: AND a.auditor_id <> -1

Line 510: -- preseeded auditor with no association with FND_USER

506: *=======================================================================*/
507: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
508: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
509: IS
510: -- preseeded auditor with no association with FND_USER
511: l_assignee NUMBER := -1;
512: -- an extremely large number
513: l_assignee_adjusted_workload NUMBER := 10E124;
514: l_auditor_info_cur GenRefCursor;

Line 942: FND_USER u,

938: (SELECT
939: u.user_id,
940: FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
941: FROM
942: FND_USER u,
943: FND_USER_RESP_GROUPS g,
944: FND_RESPONSIBILITY r,
945: FND_FORM_FUNCTIONS f
946: WHERE

Line 943: FND_USER_RESP_GROUPS g,

939: u.user_id,
940: FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
941: FROM
942: FND_USER u,
943: FND_USER_RESP_GROUPS g,
944: FND_RESPONSIBILITY r,
945: FND_FORM_FUNCTIONS f
946: WHERE
947: u.user_id = l_auditor_id