DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 407: hr_organization_information oi,

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

Line 460: hr_organization_information oi

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