APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on PER_ORGANIZATION_LIST

Line 409: per_organization_list per,

405: AP_WEB_UTILITIES_PKG.LogProcedure(G_PKG_NAME, 'start open_auditors_info_cursor:' || p_report_header_id || ' p_org_id:' || p_org_id);
406: OPEN p_auditor_info_cur FOR
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

Line 477: per_organization_list per,

473: ( SELECT q.expense_report_id
474: FROM ap_aud_queues q,
475: ap_expense_report_headers_all e,
476: ap_aud_auditors a,
477: per_organization_list per,
478: hr_organization_information oi
479: WHERE q.auditor_id = a.auditor_id
480: AND q.expense_report_id = e.report_header_id
481: AND a.security_profile_id = per.security_profile_id