[Home] [Help]
250: least(greatest(0,unmitigated_risks+l_ineff_diff),risks_evaluated+l_evaluated_diff,total_risks)
251: WHERE audit_project_id = l_pk2
252: AND organization_id = l_pk3
253: AND process_id IN (SELECT process_id
254: FROM amw_execution_scope
255: START WITH process_id = l_pk4
256: AND organization_id = l_pk3
257: AND entity_id = l_pk2
258: AND entity_type = 'PROJECT'
284: least(greatest(0,ineffective_controls+l_ineff_diff),controls_evaluated+l_evaluated_diff,total_controls)
285: WHERE audit_project_id = l_pk2
286: AND organization_id = l_pk3
287: AND process_id IN (SELECT process_id
288: FROM amw_execution_scope
289: START WITH process_id IN ( SELECT pk3
290: FROM amw_control_associations
291: WHERE object_type = 'PROJECT'
292: AND control_id = l_pk1
381: AND parent_object_id = PRIOR object_id);
382:
383: CURSOR get_total_processes IS
384: SELECT count(distinct process_id)
385: FROM amw_execution_scope
386: WHERE entity_type = 'PROJECT'
387: AND entity_id = p_audit_project_id
388: AND organization_id = p_org_id;
389:
393: WHERE opinion_type_code = 'EVALUATION'
394: AND object_name = 'AMW_ORG_PROCESS'
395: AND pk2_value = p_audit_project_id
396: AND pk3_value = p_org_id
397: AND exists (select 'Y' from amw_execution_scope scope
398: where scope.entity_type='PROJECT'
399: and scope.entity_id=p_audit_project_id
400: and scope.organization_id=opin.pk3_value
401: and scope.process_id=opin.pk1_value);
407: AND object_name = 'AMW_ORG_PROCESS'
408: AND audit_result_code <> 'EFFECTIVE'
409: AND pk2_value = p_audit_project_id
410: AND pk3_value = p_org_id
411: AND exists (select 'Y' from amw_execution_scope scope
412: where scope.entity_type='PROJECT'
413: and scope.entity_id=p_audit_project_id
414: and scope.organization_id=opin.pk3_value
415: and scope.process_id=opin.pk1_value);
656: WHERE object_type = 'PROJECT'
657: AND pk1 = p_audit_project_id
658: AND pk2 = p_org_id
659: AND pk3 IN (SELECT process_id
660: FROM amw_execution_scope
661: START WITH process_id = p_proc_id
662: AND organization_id = p_org_id
663: AND entity_id = p_audit_project_id
664: AND entity_type = 'PROJECT'
674: AND object_name = 'AMW_ORG_PROCESS_RISK'
675: AND pk2_value = p_audit_project_id
676: AND pk3_value = p_org_id
677: AND pk4_value IN (SELECT process_id
678: FROM amw_execution_scope
679: START WITH process_id = p_proc_id
680: AND organization_id = p_org_id
681: AND entity_id = p_audit_project_id
682: AND entity_type = 'PROJECT'
699: AND audit_result_code <> 'EFFECTIVE'
700: AND pk2_value = p_audit_project_id
701: AND pk3_value = p_org_id
702: AND pk4_value IN (SELECT process_id
703: FROM amw_execution_scope
704: START WITH process_id = p_proc_id
705: AND organization_id = p_org_id
706: AND entity_id = p_audit_project_id
707: AND entity_type = 'PROJECT'
722: WHERE object_type = 'PROJECT'
723: AND pk1 = p_audit_project_id
724: AND pk2 = p_org_id
725: AND pk3 IN (SELECT process_id
726: FROM amw_execution_scope
727: START WITH process_id = p_proc_id
728: AND organization_id = p_org_id
729: AND entity_id = p_audit_project_id
730: AND entity_type = 'PROJECT'
739: WHERE assoc.object_type = 'PROJECT'
740: AND assoc.pk1 = p_audit_project_id
741: AND assoc.pk2 = p_org_id
742: AND assoc.pk3 IN (SELECT process_id
743: FROM amw_execution_scope
744: START WITH process_id = p_proc_id
745: AND organization_id = p_org_id
746: AND entity_id = p_audit_project_id
747: AND entity_type = 'PROJECT'
761: WHERE assoc.object_type = 'PROJECT'
762: AND assoc.pk1 = p_audit_project_id
763: AND assoc.pk2 = p_org_id
764: AND assoc.pk3 IN (SELECT process_id
765: FROM amw_execution_scope
766: START WITH process_id = p_proc_id
767: AND organization_id = p_org_id
768: AND entity_id = p_audit_project_id
769: AND entity_type = 'PROJECT'