575: risk.RISK_REV_ID
576: FROM
577: AMW_RISK_ASSOCIATIONS risks,
578: AMW_FIN_PROCESS_EVAL_SUM eval,
579: AMW_RISKS_B risk
580: WHERE
581: eval.fin_certification_id = p_certification_id
582: and risk.risk_id = risks.risk_id
583: and risk.CURR_APPROVED_FLAG = 'Y'
599: risk.RISK_REV_ID
600: FROM
601: AMW_RISK_ASSOCIATIONS risks,
602: AMW_FIN_PROCESS_EVAL_SUM eval,
603: AMW_RISKS_B risk
604: WHERE
605: eval.fin_certification_id = p_certification_id
606: and risk.risk_id = risks.risk_id
607: and risk.CURR_APPROVED_FLAG = 'Y'