APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_RISKS_ALL_VL

Line 216: AMW_RISKS_ALL_VL all_risks,

212: op.authored_date, /*last_evaluated_on*/
213: all_risks.risk_rev_id,
214: op.audit_result_code
215: FROM AMW_RISK_ASSOCIATIONS risks,
216: AMW_RISKS_ALL_VL all_risks,
217: AMW_PROCESS_ORGANIZATION_VL proc,
218: HR_ALL_ORGANIZATION_UNITS o,
219: HR_ALL_ORGANIZATION_UNITS_TL otl,
220: AMW_OPINIONS_LOG_V op,

Line 252: amw_risks_all_vl risktable,

248: procorg.display_name as process_name,
249: assoctable.risk_rev_id as risk_rev_id,
250: opinionstable.audit_result_code as audit_result_code
251: FROM amw_risk_associations assoctable,
252: amw_risks_all_vl risktable,
253: amw_audit_units_v orgtable,
254: amw_opinions_log_v opinionstable,
255: amw_execution_scope execs,
256: AMW_PROCESS_ORGANIZATION_VL procorg