APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_OPINIONS_V

Line 746: FROM amw_control_associations aca,amw_opinions_v aov

742: CURSOR c_get_risks_with_ineff_ctrls
743: IS
744: SELECT count(1)
745: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id
746: FROM amw_control_associations aca,amw_opinions_v aov
747: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
748: AND aca.pk1 = p_cert_id
749: AND aca.pk2 = p_org_id
750: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 904: FROM amw_opinions_v opinion

900:
901: CURSOR c_get_certification_opinion
902: IS
903: SELECT opinion.opinion_id,opinion.audit_result_code
904: FROM amw_opinions_v opinion
905: WHERE opinion.pk3_value = p_org_id
906: AND opinion.pk2_value = cert_rec.cert_id
907: AND opinion.pk1_value = p_process_id
908: AND opinion.opinion_type_code = 'CERTIFICATION'

Line 914: FROM amw_control_associations aca,amw_opinions_v aov

910: CURSOR c_get_risks_with_ineff_ctrls
911: IS
912: SELECT count(1)
913: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id
914: FROM amw_control_associations aca,amw_opinions_v aov
915: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
916: AND aca.pk1 = cert_rec.cert_id
917: AND aca.pk2 = p_org_id
918: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 982: v_certification_result amw_opinions_v.audit_result%type;

978: v_proc_name VARCHAR2(50);
979: r_certification_opinion c_get_certification_opinion%rowtype;
980: r_get_risk_evals c_get_risk_evals%rowtype;
981: r_get_control_evals c_get_control_evals%rowtype;
982: v_certification_result amw_opinions_v.audit_result%type;
983: v_cert_with_issues rci_proc_cert_sum_f.CERT_RESULT_CWI%type := 0;
984: v_certified rci_proc_cert_sum_f.CERT_RESULT_C%type := 0;
985: v_not_certified rci_proc_cert_sum_f.CERT_RESULT_NC%type := 0;
986: v_risks_with_ineff_ctrls NUMBER;