eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_PROCESS_ORGANIZATION

Line 192: (Select distinct count(*) from AMW_PROCESS_ORGANIZATION processorg where

188: -- the process is executed in
189: g_user_id := fnd_global.user_id;
190: Update AMW_PROC_CERT_EVAL_SUM
191: SET TOTAL_ORG_PROCESS_CERT =
192: (Select distinct count(*) from AMW_PROCESS_ORGANIZATION processorg where
193: (processorg.PROCESS_ID = p_process_id) and
194: (processorg.ORGANIZATION_ID = p_global_org_id))
195: , GLOBAL_PROCESS ='Y', LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = G_USER_ID
196: where PROCESS_ID = p_process_id and CERTIFICATION_ID = p_certification_id

Line 310: AMW_PROCESS_ORGANIZATION procorg

306: amw_opinion_types_tl optypes,
307: AMW_OBJECT_OPINION_TYPES objoptypes,
308: amw_opinions_v opinionstable,
309: pa_project_lists_v pap,
310: AMW_PROCESS_ORGANIZATION procorg
311:
312: where assoctable.object_type = 'PROCESS_ORG'
313: and orgtable.organization_id = procorg.organization_id
314: and processtable.process_id = procorg.process_id

Line 381: amw_process_organization procorg,

377: (select distinct Count(*)
378:
379: from amw_control_associations ctrlassoc,
380: amw_risk_associations riskassoc,
381: amw_process_organization procorg,
382: amw_controls_all_vl controltable,
383: amw_audit_units_v orgtable,
384: amw_wf_org_hierarchy_main_v processtable,
385: fnd_objects fo,

Line 455: AMW_ACCT_ASSOCIATIONS acct_assoc, AMW_PROCESS_ORGANIZATION process_org

451: cursor proc is
452:
453: select process_id, organization_id
454: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc,
455: AMW_ACCT_ASSOCIATIONS acct_assoc, AMW_PROCESS_ORGANIZATION process_org
456: where cert.certification_id = p_certification_id and cert.object_type = 'FIN_STMT'
457: and cert.statement_group_id = key_acc.statement_group_id and
458: cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID and
459: acct_assoc.natural_account_id = key_acc.natural_account_id and

Line 575: AMW_PROCESS_ORGANIZATION process_org,

571: AND object_type = 'PROCESS_ORG'
572: AND pk1 in (
573: select distinct p_org.process_organization_id
574: from AMW_ACCT_ASSOCIATIONS acct_assoc,
575: AMW_PROCESS_ORGANIZATION process_org,
576: AMW_PROCESS_ORGANIZATION p_org,
577: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
578: from Amw_Org_Hierarchy_Denorm
579: union

Line 576: AMW_PROCESS_ORGANIZATION p_org,

572: AND pk1 in (
573: select distinct p_org.process_organization_id
574: from AMW_ACCT_ASSOCIATIONS acct_assoc,
575: AMW_PROCESS_ORGANIZATION process_org,
576: AMW_PROCESS_ORGANIZATION p_org,
577: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
578: from Amw_Org_Hierarchy_Denorm
579: union
580: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 581: from amw_process_organization) hier

577: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
578: from Amw_Org_Hierarchy_Denorm
579: union
580: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
581: from amw_process_organization) hier
582: where acct_assoc.natural_account_id in
583: -- (select natural_account_id
584: -- from amw_fin_key_accounts_b
585: -- start with (natural_account_id, account_group_id) in

Line 640: AMW_PROCESS_ORGANIZATION apo,

636: FROM (
637: SELECT distinct aca.control_id, p_org.organization_id
638: FROM AMW_CONTROL_ASSOCIATIONS aca,
639: AMW_RISK_ASSOCIATIONS ara,
640: AMW_PROCESS_ORGANIZATION apo,
641: AMW_ACCT_ASSOCIATIONS acct_assoc,
642: AMW_PROCESS_ORGANIZATION p_org,
643: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
644: from Amw_Org_Hierarchy_Denorm

Line 642: AMW_PROCESS_ORGANIZATION p_org,

638: FROM AMW_CONTROL_ASSOCIATIONS aca,
639: AMW_RISK_ASSOCIATIONS ara,
640: AMW_PROCESS_ORGANIZATION apo,
641: AMW_ACCT_ASSOCIATIONS acct_assoc,
642: AMW_PROCESS_ORGANIZATION p_org,
643: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
644: from Amw_Org_Hierarchy_Denorm
645: union
646: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 647: from amw_process_organization) hier

643: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
644: from Amw_Org_Hierarchy_Denorm
645: union
646: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
647: from amw_process_organization) hier
648: WHERE acct_assoc.natural_account_id in
649: -- (select natural_account_id
650: -- from amw_fin_key_accounts_b
651: -- start with (natural_account_id, account_group_id) in

Line 713: FROM AMW_PROCESS_ORGANIZATION apo,

709: CURSOR global_proc_not_certified IS
710: SELECT count(1)
711: FROM (
712: SELECT distinct hier.organization_id, hier.child_process_id
713: FROM AMW_PROCESS_ORGANIZATION apo,
714: AMW_ACCT_ASSOCIATIONS acct_assoc,
715: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
716: from Amw_Org_Hierarchy_Denorm
717: union

Line 719: from amw_process_organization) hier

715: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
716: from Amw_Org_Hierarchy_Denorm
717: union
718: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
719: from amw_process_organization) hier
720: WHERE acct_assoc.natural_account_id in
721: -- (select natural_account_id
722: -- from amw_fin_key_accounts_b
723: -- start with (natural_account_id, account_group_id) in

Line 776: FROM AMW_PROCESS_ORGANIZATION apo,

772: CURSOR global_proc_with_issue IS
773: SELECT count(1)
774: FROM (
775: SELECT distinct hier.organization_id, hier.child_process_id
776: FROM AMW_PROCESS_ORGANIZATION apo,
777: AMW_ACCT_ASSOCIATIONS acct_assoc,
778: AMW_OPINIONS_V aov,
779: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
780: from Amw_Org_Hierarchy_Denorm

Line 783: from amw_process_organization) hier

779: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
780: from Amw_Org_Hierarchy_Denorm
781: union
782: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
783: from amw_process_organization) hier
784: WHERE acct_assoc.natural_account_id in
785: -- (select natural_account_id
786: -- from amw_fin_key_accounts_b
787: -- start with (natural_account_id, account_group_id) in

Line 837: FROM AMW_PROCESS_ORGANIZATION apo,

833:
834: CURSOR local_proc_not_certified IS
835: SELECT count(1)
836: FROM (SELECT distinct hier.organization_id, hier.child_process_id
837: FROM AMW_PROCESS_ORGANIZATION apo,
838: AMW_ACCT_ASSOCIATIONS acct_assoc,
839: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
840: from Amw_Org_Hierarchy_Denorm
841: union

Line 843: from amw_process_organization) hier

839: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
840: from Amw_Org_Hierarchy_Denorm
841: union
842: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
843: from amw_process_organization) hier
844: WHERE acct_assoc.natural_account_id in
845: -- (select natural_account_id
846: -- from amw_fin_key_accounts_b
847: -- start with (natural_account_id, account_group_id) in

Line 897: FROM AMW_PROCESS_ORGANIZATION apo,

893:
894: CURSOR local_proc_with_issue IS
895: SELECT count(1)
896: FROM (SELECT distinct hier.organization_id, hier.child_process_id
897: FROM AMW_PROCESS_ORGANIZATION apo,
898: AMW_ACCT_ASSOCIATIONS acct_assoc,
899: AMW_OPINIONS_V aov,
900: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
901: from Amw_Org_Hierarchy_Denorm

Line 904: from amw_process_organization) hier

900: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
901: from Amw_Org_Hierarchy_Denorm
902: union
903: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
904: from amw_process_organization) hier
905: WHERE acct_assoc.natural_account_id in
906: -- (select natural_account_id
907: -- from amw_fin_key_accounts_b
908: -- start with (natural_account_id, account_group_id) in

Line 956: FROM AMW_PROCESS_ORGANIZATION apo,

952: AND aov.audit_result_code <> 'EFFECTIVE');
953:
954: CURSOR global_proc_with_ineff_ctrl IS
955: SELECT count(distinct hier.child_process_id)
956: FROM AMW_PROCESS_ORGANIZATION apo,
957: AMW_ACCT_ASSOCIATIONS acct_assoc,
958: AMW_OPINIONS_V aov,
959: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
960: from Amw_Org_Hierarchy_Denorm

Line 963: from amw_process_organization) hier

959: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
960: from Amw_Org_Hierarchy_Denorm
961: union
962: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
963: from amw_process_organization) hier
964: WHERE acct_assoc.natural_account_id in
965: -- (select natural_account_id
966: -- from amw_fin_key_accounts_b
967: -- start with (natural_account_id, account_group_id) in

Line 1020: FROM AMW_PROCESS_ORGANIZATION apo,

1016:
1017: CURSOR local_proc_with_ineff_ctrl IS
1018: SELECT count(1)
1019: FROM (SELECT distinct hier.organization_id, hier.child_process_id
1020: FROM AMW_PROCESS_ORGANIZATION apo,
1021: AMW_ACCT_ASSOCIATIONS acct_assoc,
1022: AMW_OPINIONS_V aov,
1023: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1024: from Amw_Org_Hierarchy_Denorm

Line 1027: from amw_process_organization) hier

1023: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1024: from Amw_Org_Hierarchy_Denorm
1025: union
1026: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1027: from amw_process_organization) hier
1028: WHERE acct_assoc.natural_account_id in
1029:
1030: -- (select natural_account_id
1031: -- from amw_fin_key_accounts_b

Line 1086: FROM AMW_PROCESS_ORGANIZATION apo,

1082:
1083: CURSOR unmitigated_risks IS
1084: SELECT count(1)
1085: FROM (SELECT distinct p_org.organization_id, p_org.process_id, ara.risk_id
1086: FROM AMW_PROCESS_ORGANIZATION apo,
1087: AMW_ACCT_ASSOCIATIONS acct_assoc,
1088: AMW_RISK_ASSOCIATIONS ara,
1089: AMW_OPINIONS_V aov,
1090: AMW_PROCESS_ORGANIZATION p_org,

Line 1090: AMW_PROCESS_ORGANIZATION p_org,

1086: FROM AMW_PROCESS_ORGANIZATION apo,
1087: AMW_ACCT_ASSOCIATIONS acct_assoc,
1088: AMW_RISK_ASSOCIATIONS ara,
1089: AMW_OPINIONS_V aov,
1090: AMW_PROCESS_ORGANIZATION p_org,
1091: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1092: from Amw_Org_Hierarchy_Denorm
1093: union
1094: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 1095: from amw_process_organization) hier

1091: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1092: from Amw_Org_Hierarchy_Denorm
1093: union
1094: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1095: from amw_process_organization) hier
1096: WHERE acct_assoc.natural_account_id in
1097:
1098: -- (select natural_account_id
1099: -- from amw_fin_key_accounts_b

Line 1159: FROM AMW_PROCESS_ORGANIZATION apo,

1155:
1156: CURSOR ineffective_controls IS
1157: SELECT count(1)
1158: FROM (SELECT distinct p_org.organization_id, aca.control_id
1159: FROM AMW_PROCESS_ORGANIZATION apo,
1160: AMW_ACCT_ASSOCIATIONS acct_assoc,
1161: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1162: AMW_OPINIONS_V aov,
1163: AMW_PROCESS_ORGANIZATION p_org,

Line 1163: AMW_PROCESS_ORGANIZATION p_org,

1159: FROM AMW_PROCESS_ORGANIZATION apo,
1160: AMW_ACCT_ASSOCIATIONS acct_assoc,
1161: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1162: AMW_OPINIONS_V aov,
1163: AMW_PROCESS_ORGANIZATION p_org,
1164: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1165: from Amw_Org_Hierarchy_Denorm
1166: union
1167: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 1168: from amw_process_organization) hier

1164: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1165: from Amw_Org_Hierarchy_Denorm
1166: union
1167: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1168: from amw_process_organization) hier
1169: WHERE acct_assoc.natural_account_id in
1170:
1171: -- (select natural_account_id
1172: -- from amw_fin_key_accounts_b

Line 1232: FROM AMW_PROCESS_ORGANIZATION apo,

1228:
1229:
1230: CURSOR orgs_pending_in_scope IS
1231: SELECT count(distinct p_org.organization_id)
1232: FROM AMW_PROCESS_ORGANIZATION apo,
1233: AMW_ACCT_ASSOCIATIONS acct_assoc,
1234: AMW_PROCESS_ORGANIZATION p_org,
1235: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1236: from Amw_Org_Hierarchy_Denorm

Line 1234: AMW_PROCESS_ORGANIZATION p_org,

1230: CURSOR orgs_pending_in_scope IS
1231: SELECT count(distinct p_org.organization_id)
1232: FROM AMW_PROCESS_ORGANIZATION apo,
1233: AMW_ACCT_ASSOCIATIONS acct_assoc,
1234: AMW_PROCESS_ORGANIZATION p_org,
1235: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1236: from Amw_Org_Hierarchy_Denorm
1237: union
1238: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 1239: from amw_process_organization) hier

1235: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1236: from Amw_Org_Hierarchy_Denorm
1237: union
1238: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1239: from amw_process_organization) hier
1240: WHERE acct_assoc.natural_account_id in
1241:
1242: -- (select natural_account_id
1243: -- from amw_fin_key_accounts_b

Line 1294: FROM AMW_PROCESS_ORGANIZATION apo,

1290: AND aov.pk1_value = p_org.process_id);
1291:
1292: CURSOR orgs_in_scope IS
1293: SELECT count(distinct apo.organization_id)
1294: FROM AMW_PROCESS_ORGANIZATION apo,
1295: AMW_ACCT_ASSOCIATIONS acct_assoc
1296: WHERE acct_assoc.natural_account_id in
1297:
1298: -- (select natural_account_id

Line 1590: AMW_PROCESS_ORGANIZATION po,

1586: CURSOR total_org_processes IS
1587: SELECT count(distinct po.organization_id)
1588: FROM AMW_ACCT_ASSOCIATIONS aa,
1589: AMW_FIN_ITEMS_KEY_ACC fika,
1590: AMW_PROCESS_ORGANIZATION po,
1591: AMW_CERTIFICATION_B cert
1592: WHERE aa.object_type = 'PROCESS_ORG'
1593: AND aa.pk1 = po.process_organization_id
1594: AND aa.natural_account_id in

Line 1655: FROM AMW_PROCESS_ORGANIZATION apo,

1651: and aov2.pk1_value = aov.pk1_value);
1652:
1653: CURSOR unmitigated_risks IS
1654: SELECT count(1)
1655: FROM AMW_PROCESS_ORGANIZATION apo,
1656: AMW_RISK_ASSOCIATIONS ara,
1657: AMW_OPINIONS_V aov
1658: WHERE apo.organization_id = p_organization_id
1659: AND apo.process_id in ( select distinct(orgrel.child_process_id)

Line 1687: FROM AMW_PROCESS_ORGANIZATION apo,

1683:
1684:
1685: CURSOR ineffective_controls IS
1686: SELECT count(distinct aca.control_id)
1687: FROM AMW_PROCESS_ORGANIZATION apo,
1688: AMW_RISK_ASSOCIATIONS ara,
1689: AMW_CONTROL_ASSOCIATIONS aca,
1690: AMW_OPINIONS_V aov
1691: WHERE apo.organization_id = p_organization_id

Line 1991: AMW_PROCESS_ORGANIZATION po,

1987: CURSOR c_process(p_cert_id NUMBER) IS
1988: SELECT distinct aa.pk1 process_organization_id,po.process_id,po.organization_id
1989: FROM AMW_ACCT_ASSOCIATIONS aa,
1990: AMW_FIN_ITEMS_KEY_ACC fika,
1991: AMW_PROCESS_ORGANIZATION po,
1992: AMW_CERTIFICATION_B cert
1993: WHERE aa.object_type = 'PROCESS_ORG'
1994: AND aa.pk1 = po.process_organization_id
1995: AND aa.natural_account_id in

Line 2251: AMW_PROCESS_ORGANIZATION apo,

2247: SELECT count(distinct apo.process_id)
2248: FROM AMW_ACCT_ASSOCIATIONS aa,
2249: AMW_FIN_ITEMS_KEY_ACC fika,
2250: AMW_CERTIFICATION_B cert,
2251: AMW_PROCESS_ORGANIZATION apo,
2252: AMW_PROCESS_ORGANIZATION apo2
2253: WHERE aa.object_type = 'PROCESS_ORG'
2254: AND apo2.process_organization_id = aa.pk1
2255: AND (apo.process_id, apo.organization_id) in

Line 2252: AMW_PROCESS_ORGANIZATION apo2

2248: FROM AMW_ACCT_ASSOCIATIONS aa,
2249: AMW_FIN_ITEMS_KEY_ACC fika,
2250: AMW_CERTIFICATION_B cert,
2251: AMW_PROCESS_ORGANIZATION apo,
2252: AMW_PROCESS_ORGANIZATION apo2
2253: WHERE aa.object_type = 'PROCESS_ORG'
2254: AND apo2.process_organization_id = aa.pk1
2255: AND (apo.process_id, apo.organization_id) in
2256: (select child_process_id, organization_id

Line 2297: AMW_PROCESS_ORGANIZATION po,

2293: */
2294: CURSOR total_num_of_proc IS
2295: SELECT count(distinct hier.parent_child_id)
2296: FROM AMW_ACCT_ASSOCIATIONS aa,
2297: AMW_PROCESS_ORGANIZATION po,
2298: (select process_id, organization_id, parent_child_id, up_down_ind
2299: from Amw_Org_Hierarchy_Denorm hier
2300: union select process_id, organization_id, process_id, 'D'
2301: from amw_process_organization) hier

Line 2301: from amw_process_organization) hier

2297: AMW_PROCESS_ORGANIZATION po,
2298: (select process_id, organization_id, parent_child_id, up_down_ind
2299: from Amw_Org_Hierarchy_Denorm hier
2300: union select process_id, organization_id, process_id, 'D'
2301: from amw_process_organization) hier
2302: WHERE aa.object_type = 'PROCESS_ORG'
2303: AND po.process_organization_id = aa.pk1
2304: AND hier.organization_id = po.organization_id
2305: AND hier.process_id = po.process_id

Line 2348: AMW_PROCESS_ORGANIZATION po,

2344:
2345: CURSOR proc_with_issue IS
2346: SELECT count(distinct hier.parent_child_id)
2347: FROM AMW_ACCT_ASSOCIATIONS aa,
2348: AMW_PROCESS_ORGANIZATION po,
2349: (select process_id, organization_id, parent_child_id, up_down_ind
2350: from Amw_Org_Hierarchy_Denorm hier
2351: union select process_id, organization_id, process_id, 'D'
2352: from amw_process_organization) hier,

Line 2352: from amw_process_organization) hier,

2348: AMW_PROCESS_ORGANIZATION po,
2349: (select process_id, organization_id, parent_child_id, up_down_ind
2350: from Amw_Org_Hierarchy_Denorm hier
2351: union select process_id, organization_id, process_id, 'D'
2352: from amw_process_organization) hier,
2353: AMW_OPINIONS_V aov
2354: WHERE aa.object_type = 'PROCESS_ORG'
2355: AND po.process_organization_id = aa.pk1
2356: AND hier.organization_id = po.organization_id

Line 2416: AMW_PROCESS_ORGANIZATION po,

2412:
2413: CURSOR proc_without_issue IS
2414: SELECT count(distinct hier.parent_child_id)
2415: FROM AMW_ACCT_ASSOCIATIONS aa,
2416: AMW_PROCESS_ORGANIZATION po,
2417: (select process_id, organization_id, parent_child_id, up_down_ind
2418: from Amw_Org_Hierarchy_Denorm hier
2419: union select process_id, organization_id, process_id, 'D'
2420: from amw_process_organization) hier,

Line 2420: from amw_process_organization) hier,

2416: AMW_PROCESS_ORGANIZATION po,
2417: (select process_id, organization_id, parent_child_id, up_down_ind
2418: from Amw_Org_Hierarchy_Denorm hier
2419: union select process_id, organization_id, process_id, 'D'
2420: from amw_process_organization) hier,
2421: AMW_OPINIONS_V aov
2422: WHERE aa.object_type = 'PROCESS_ORG'
2423: AND po.process_organization_id = aa.pk1
2424: AND hier.organization_id = po.organization_id

Line 2483: AMW_PROCESS_ORGANIZATION po,

2479:
2480: CURSOR proc_with_ineff_ctrl IS
2481: SELECT count(distinct hier.parent_child_id)
2482: FROM AMW_ACCT_ASSOCIATIONS aa,
2483: AMW_PROCESS_ORGANIZATION po,
2484: (select process_id, organization_id, parent_child_id, up_down_ind
2485: from Amw_Org_Hierarchy_Denorm hier
2486: union select process_id, organization_id, process_id, 'D'
2487: from amw_process_organization) hier,

Line 2487: from amw_process_organization) hier,

2483: AMW_PROCESS_ORGANIZATION po,
2484: (select process_id, organization_id, parent_child_id, up_down_ind
2485: from Amw_Org_Hierarchy_Denorm hier
2486: union select process_id, organization_id, process_id, 'D'
2487: from amw_process_organization) hier,
2488: AMW_OPINIONS_V aov
2489: WHERE aa.object_type = 'PROCESS_ORG'
2490: AND po.process_organization_id = aa.pk1
2491: AND hier.organization_id = po.organization_id

Line 2545: AMW_PROCESS_ORGANIZATION po,

2541:
2542: CURSOR unmitigated_risks IS
2543: SELECT count(distinct ara.risk_association_id)
2544: FROM AMW_ACCT_ASSOCIATIONS aa,
2545: AMW_PROCESS_ORGANIZATION po,
2546: (select process_id, organization_id, parent_child_id, up_down_ind
2547: from Amw_Org_Hierarchy_Denorm hier
2548: union select process_id, organization_id, process_id, 'D'
2549: from amw_process_organization) hier,

Line 2549: from amw_process_organization) hier,

2545: AMW_PROCESS_ORGANIZATION po,
2546: (select process_id, organization_id, parent_child_id, up_down_ind
2547: from Amw_Org_Hierarchy_Denorm hier
2548: union select process_id, organization_id, process_id, 'D'
2549: from amw_process_organization) hier,
2550: AMW_PROCESS_ORGANIZATION po2,
2551: AMW_RISK_ASSOCIATIONS ara,
2552: AMW_OPINIONS_V aov
2553: WHERE aa.object_type = 'PROCESS_ORG'

Line 2550: AMW_PROCESS_ORGANIZATION po2,

2546: (select process_id, organization_id, parent_child_id, up_down_ind
2547: from Amw_Org_Hierarchy_Denorm hier
2548: union select process_id, organization_id, process_id, 'D'
2549: from amw_process_organization) hier,
2550: AMW_PROCESS_ORGANIZATION po2,
2551: AMW_RISK_ASSOCIATIONS ara,
2552: AMW_OPINIONS_V aov
2553: WHERE aa.object_type = 'PROCESS_ORG'
2554: AND po.process_organization_id = aa.pk1

Line 2614: AMW_PROCESS_ORGANIZATION po,

2610:
2611: CURSOR total_risks IS
2612: SELECT count(distinct ara.risk_association_id)
2613: FROM AMW_ACCT_ASSOCIATIONS aa,
2614: AMW_PROCESS_ORGANIZATION po,
2615: (select process_id, organization_id, parent_child_id, up_down_ind
2616: from Amw_Org_Hierarchy_Denorm hier
2617: union select process_id, organization_id, process_id, 'D'
2618: from amw_process_organization) hier,

Line 2618: from amw_process_organization) hier,

2614: AMW_PROCESS_ORGANIZATION po,
2615: (select process_id, organization_id, parent_child_id, up_down_ind
2616: from Amw_Org_Hierarchy_Denorm hier
2617: union select process_id, organization_id, process_id, 'D'
2618: from amw_process_organization) hier,
2619: AMW_PROCESS_ORGANIZATION po2,
2620: AMW_RISK_ASSOCIATIONS ara
2621: WHERE aa.object_type = 'PROCESS_ORG'
2622: AND po.process_organization_id = aa.pk1

Line 2619: AMW_PROCESS_ORGANIZATION po2,

2615: (select process_id, organization_id, parent_child_id, up_down_ind
2616: from Amw_Org_Hierarchy_Denorm hier
2617: union select process_id, organization_id, process_id, 'D'
2618: from amw_process_organization) hier,
2619: AMW_PROCESS_ORGANIZATION po2,
2620: AMW_RISK_ASSOCIATIONS ara
2621: WHERE aa.object_type = 'PROCESS_ORG'
2622: AND po.process_organization_id = aa.pk1
2623: AND hier.organization_id = po.organization_id

Line 2670: AMW_PROCESS_ORGANIZATION po,

2666:
2667: CURSOR ineffective_controls IS
2668: SELECT count(distinct aca.control_id)
2669: FROM AMW_ACCT_ASSOCIATIONS aa,
2670: AMW_PROCESS_ORGANIZATION po,
2671: (select process_id, organization_id, parent_child_id, up_down_ind
2672: from Amw_Org_Hierarchy_Denorm hier
2673: union select process_id, organization_id, process_id, 'D'
2674: from amw_process_organization) hier,

Line 2674: from amw_process_organization) hier,

2670: AMW_PROCESS_ORGANIZATION po,
2671: (select process_id, organization_id, parent_child_id, up_down_ind
2672: from Amw_Org_Hierarchy_Denorm hier
2673: union select process_id, organization_id, process_id, 'D'
2674: from amw_process_organization) hier,
2675: AMW_PROCESS_ORGANIZATION po2,
2676: AMW_RISK_ASSOCIATIONS ara,
2677: AMW_CONTROL_ASSOCIATIONS aca ,
2678: AMW_OPINIONS_V aov

Line 2675: AMW_PROCESS_ORGANIZATION po2,

2671: (select process_id, organization_id, parent_child_id, up_down_ind
2672: from Amw_Org_Hierarchy_Denorm hier
2673: union select process_id, organization_id, process_id, 'D'
2674: from amw_process_organization) hier,
2675: AMW_PROCESS_ORGANIZATION po2,
2676: AMW_RISK_ASSOCIATIONS ara,
2677: AMW_CONTROL_ASSOCIATIONS aca ,
2678: AMW_OPINIONS_V aov
2679: WHERE aa.object_type = 'PROCESS_ORG'

Line 2741: AMW_PROCESS_ORGANIZATION po,

2737:
2738: CURSOR total_controls IS
2739: SELECT count(distinct aca.control_id)
2740: FROM AMW_ACCT_ASSOCIATIONS aa,
2741: AMW_PROCESS_ORGANIZATION po,
2742: (select process_id, organization_id, parent_child_id, up_down_ind
2743: from Amw_Org_Hierarchy_Denorm hier
2744: union select process_id, organization_id, process_id, 'D'
2745: from amw_process_organization) hier,

Line 2745: from amw_process_organization) hier,

2741: AMW_PROCESS_ORGANIZATION po,
2742: (select process_id, organization_id, parent_child_id, up_down_ind
2743: from Amw_Org_Hierarchy_Denorm hier
2744: union select process_id, organization_id, process_id, 'D'
2745: from amw_process_organization) hier,
2746: AMW_PROCESS_ORGANIZATION po2,
2747: AMW_RISK_ASSOCIATIONS ara,
2748: AMW_CONTROL_ASSOCIATIONS aca
2749: WHERE aa.object_type = 'PROCESS_ORG'

Line 2746: AMW_PROCESS_ORGANIZATION po2,

2742: (select process_id, organization_id, parent_child_id, up_down_ind
2743: from Amw_Org_Hierarchy_Denorm hier
2744: union select process_id, organization_id, process_id, 'D'
2745: from amw_process_organization) hier,
2746: AMW_PROCESS_ORGANIZATION po2,
2747: AMW_RISK_ASSOCIATIONS ara,
2748: AMW_CONTROL_ASSOCIATIONS aca
2749: WHERE aa.object_type = 'PROCESS_ORG'
2750: AND po.process_organization_id = aa.pk1

Line 3030: AMW_PROCESS_ORGANIZATION po,

3026: CURSOR c_org(p_cert_id NUMBER) IS
3027: SELECT distinct po.organization_id
3028: FROM AMW_ACCT_ASSOCIATIONS aa,
3029: AMW_FIN_ITEMS_KEY_ACC fika,
3030: AMW_PROCESS_ORGANIZATION po,
3031: AMW_CERTIFICATION_B cert
3032: WHERE aa.object_type = 'PROCESS_ORG'
3033: AND aa.pk1 = po.process_organization_id
3034: AND aa.natural_account_id in

Line 3075: AMW_PROCESS_ORGANIZATION po,

3071: and not exists
3072: (SELECT 'Y'
3073: FROM AMW_ACCT_ASSOCIATIONS aa,
3074: AMW_FIN_ITEMS_KEY_ACC fika,
3075: AMW_PROCESS_ORGANIZATION po,
3076: AMW_CERTIFICATION_B cert
3077: WHERE aa.object_type = 'PROCESS_ORG'
3078: AND aa.pk1 = po.process_organization_id
3079: AND aa.natural_account_id in

Line 3113: AMW_PROCESS_ORGANIZATION po,

3109: where not exists
3110: (SELECT 'Y'
3111: FROM AMW_ACCT_ASSOCIATIONS aa,
3112: AMW_FIN_ITEMS_KEY_ACC fika,
3113: AMW_PROCESS_ORGANIZATION po,
3114: AMW_CERTIFICATION_B cert
3115: WHERE aa.object_type = 'PROCESS_ORG'
3116: AND aa.pk1 = po.process_organization_id
3117: AND aa.natural_account_id = fika.natural_account_id