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 408: fnd_user u,

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

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

488: *=======================================================================*/
489: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
490: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
491: IS
492: -- preseeded auditor with no association with FND_USER
493: l_assignee NUMBER := -1;
494: -- an extremely large number
495: l_assignee_adjusted_workload NUMBER := 10E124;
496: l_auditor_info_cur GenRefCursor;

Line 925: FND_USER u,

921: (SELECT
922: u.user_id,
923: FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
924: FROM
925: FND_USER u,
926: FND_USER_RESP_GROUPS g,
927: FND_RESPONSIBILITY r,
928: FND_FORM_FUNCTIONS f
929: WHERE

Line 926: FND_USER_RESP_GROUPS g,

922: u.user_id,
923: FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
924: FROM
925: FND_USER u,
926: FND_USER_RESP_GROUPS g,
927: FND_RESPONSIBILITY r,
928: FND_FORM_FUNCTIONS f
929: WHERE
930: u.user_id = l_auditor_id