DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 410: hr_organization_information oi,

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
414: AND a.auditor_id <> -1

Line 478: hr_organization_information oi

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
482: AND per.organization_id = oi.organization_id