APPS.AMW_PROJECT_EVENT_PVT dependencies on AMW_RISK_ASSOCIATIONS

Line 419: FROM amw_risk_associations

415: and scope.process_id=opin.pk1_value);
416:
417: CURSOR get_total_risks IS
418: SELECT count(risk_id)
419: FROM amw_risk_associations
420: WHERE object_type = 'PROJECT'
421: AND pk1 = p_audit_project_id
422: AND pk2 = p_org_id;
423:

Line 426: FROM amw_risk_associations assoc, amw_opinions_v opin

422: AND pk2 = p_org_id;
423:
424: CURSOR get_risks_evaluated IS
425: SELECT count(opin.pk1_value)
426: FROM amw_risk_associations assoc, amw_opinions_v opin
427: WHERE assoc.object_type = 'PROJECT'
428: AND assoc.pk1 = p_audit_project_id
429: AND assoc.pk2 = p_org_id
430: AND opin.opinion_type_code = 'EVALUATION'

Line 438: FROM amw_risk_associations assoc, amw_opinions_v opin

434: AND opin.pk3_value = assoc.pk2;
435:
436: CURSOR get_unmitigated_risks IS
437: SELECT count(opin.pk1_value)
438: FROM amw_risk_associations assoc, amw_opinions_v opin
439: WHERE assoc.object_type = 'PROJECT'
440: AND assoc.pk1 = p_audit_project_id
441: AND assoc.pk2 = p_org_id
442: AND opin.opinion_type_code = 'EVALUATION'

Line 655: FROM amw_risk_associations

651: ) IS
652:
653: CURSOR get_total_risks IS
654: SELECT count(risk_id)
655: FROM amw_risk_associations
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

Line 687: AND exists (select 'Y' FROM amw_risk_associations

683: CONNECT BY PRIOR process_id = parent_process_id
684: AND organization_id = PRIOR organization_id
685: AND entity_id = PRIOR entity_id
686: AND entity_type = PRIOR entity_type)
687: AND exists (select 'Y' FROM amw_risk_associations
688: WHERE object_type = 'PROJECT'
689: AND pk1 = p_audit_project_id
690: AND pk2 = p_org_id
691: AND pk3 = pk4_value

Line 712: AND exists (select 'Y' FROM amw_risk_associations

708: CONNECT BY PRIOR process_id = parent_process_id
709: AND organization_id = PRIOR organization_id
710: AND entity_id = PRIOR entity_id
711: AND entity_type = PRIOR entity_type)
712: AND exists (select 'Y' FROM amw_risk_associations
713: WHERE object_type = 'PROJECT'
714: AND pk1 = p_audit_project_id
715: AND pk2 = p_org_id
716: AND pk3 = pk4_value