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_PROCESS_CERT_SUMMARY dependencies on AMW_RISK_ASSOCIATIONS

Line 28: UPDATE amw_risk_associations assoc

24: OPEN c_obj_opin_type_id ('AMW_ORG_PROCESS_RISK');
25: FETCH c_obj_opin_type_id INTO l_obj_opinion_type_id;
26: CLOSE c_obj_opin_type_id;
27:
28: UPDATE amw_risk_associations assoc
29: SET pk4 = (SELECT max(opinion_log_id)
30: FROM amw_opinions_log opin
31: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
32: AND opin.pk1_value = assoc.risk_id

Line 133: FROM amw_risk_associations ara, amw_opinions_v aov

129: CURSOR get_unmitigated_risks
130: IS
131: SELECT count(1)
132: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
133: FROM amw_risk_associations ara, amw_opinions_v aov
134: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
135: AND ara.pk1 = p_certification_id
136: AND ara.pk2 = p_org_id
137: AND ara.pk3 IN (SELECT DISTINCT process_id

Line 166: FROM amw_risk_associations ara, amw_opinions_v aov

162: CURSOR get_evaluated_risks
163: IS
164: SELECT count(1)
165: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
166: FROM amw_risk_associations ara, amw_opinions_v aov
167: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
168: AND ara.pk1 = p_certification_id
169: AND ara.pk2 = p_org_id
170: AND ara.pk3 IN (SELECT DISTINCT process_id

Line 194: FROM amw_risk_associations ara

190:
191: CURSOR get_total_risks
192: IS
193: SELECT count(DISTINCT ara.risk_id)
194: FROM amw_risk_associations ara
195: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
196: AND ara.pk1 = p_certification_id
197: AND ara.pk2 = p_org_id
198: AND ara.pk3 IN (SELECT DISTINCT process_id

Line 912: FROM AMW_RISK_ASSOCIATIONS

908: CURSOR new_risks_added
909: IS
910: /*
911: SELECT count(1)
912: FROM AMW_RISK_ASSOCIATIONS
913: WHERE creation_date >= p_start_date
914: AND object_type = 'PROCESS_ORG'
915: AND pk1 in (SELECT apo.process_organization_id
916: FROM AMW_CURR_APPROVED_REV_ORG_V apo, amw_execution_scope aes

Line 923: FROM AMW_RISK_ASSOCIATIONS ara,

919: AND aes.entity_type = 'BUSIPROC_CERTIFICATION'
920: AND aes.entity_id = p_certification_id);*/
921: SELECT count(1)
922: from (select distinct ara.risk_id, ara.pk1, ara.pk2
923: FROM AMW_RISK_ASSOCIATIONS ara,
924: amw_execution_scope aes,
925: ---05.24.2005 npanandi: added AmwCertificationB, AmwGlPeriodsV
926: ---in the joins below
927: amw_certification_b acb,

Line 958: AMW_RISK_ASSOCIATIONS ara,

954: IS
955: SELECT count(1)
956: FROM (SELECT distinct aca.control_id, aes.organization_id
957: FROM AMW_CONTROL_ASSOCIATIONS aca,
958: AMW_RISK_ASSOCIATIONS ara,
959: AMW_EXECUTION_SCOPE aes,
960: ---05.24.2005 npanandi: added AmwCertificationB, AmwGlPeriodsV
961: ---in the joins below
962: amw_certification_b acb,

Line 1097: AMW_RISK_ASSOCIATIONS ara,

1093: /** CURSOR unmitigated_risks IS
1094: SELECT count(1)
1095: FROM (SELECT distinct aes.organization_id, aes.process_id, ara.risk_id
1096: FROM AMW_EXECUTION_SCOPE aes, AMW_CURR_APPROVED_REV_ORG_V apo,
1097: AMW_RISK_ASSOCIATIONS ara,
1098: AMW_OPINIONS_V aov
1099: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1100: AND aes.entity_id = p_certification_id
1101: AND aes.level_id > 3

Line 1123: AMW_RISK_ASSOCIATIONS ara,

1119: CURSOR unmitigated_risks IS
1120: SELECT count(1)
1121: FROM (SELECT distinct aes.organization_id, aes.process_id, ara.risk_id
1122: FROM AMW_EXECUTION_SCOPE aes,
1123: AMW_RISK_ASSOCIATIONS ara,
1124: AMW_OPINIONS_V aov, amw_audit_units_v aauv /* 03.19.2007 npanandi: bug 5862215 -- only consider those Orgs that are valid*/
1125: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1126: AND aes.entity_id = p_certification_id
1127: AND aes.level_id > 3

Line 1154: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,

1150: /* CURSOR ineffective_controls IS
1151: SELECT count(1)
1152: FROM (SELECT distinct aes.organization_id, aca.control_id
1153: FROM AMW_EXECUTION_SCOPE aes, AMW_CURR_APPROVED_REV_ORG_V apo,
1154: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1155: AMW_OPINIONS_V aov
1156: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1157: AND aes.entity_id = p_certification_id
1158: AND aes.level_id > 3

Line 1180: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,

1176: CURSOR ineffective_controls IS
1177: SELECT count(1)
1178: FROM (SELECT distinct aes.organization_id, aca.control_id, aes.process_id /** 01/31/2007 npanandi: added processId in distinct **/
1179: FROM AMW_EXECUTION_SCOPE aes, ---AMW_CURR_APPROVED_REV_ORG_V apo,
1180: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1181: AMW_OPINIONS_V aov, amw_audit_units_v aauv /* 03.19.2007 npanandi: bug 5862215: consider only those Orgs that are valid*/
1182: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1183: AND aes.entity_id = p_certification_id
1184: AND aes.level_id > 3