DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on PER_ORGANIZATION_LIST

Line 406: per_organization_list per,

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

Line 459: per_organization_list per,

455: ( SELECT q.expense_report_id
456: FROM ap_aud_queues q,
457: ap_expense_report_headers_all e,
458: ap_aud_auditors a,
459: per_organization_list per,
460: hr_organization_information oi
461: WHERE q.auditor_id = a.auditor_id
462: AND q.expense_report_id = e.report_header_id
463: AND a.security_profile_id = per.security_profile_id