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.

APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_CONTROL_ASSOCIATIONS

Line 46: UPDATE amw_control_associations assoc

42: OPEN c_obj_opin_type_id ('AMW_ORG_CONTROL');
43: FETCH c_obj_opin_type_id INTO l_obj_opinion_type_id;
44: CLOSE c_obj_opin_type_id;
45:
46: UPDATE amw_control_associations assoc
47: SET pk5 = (SELECT max(opinion_log_id)
48: FROM amw_opinions_log opin
49: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
50: AND opin.pk1_value = assoc.control_id

Line 219: FROM amw_control_associations aca,amw_opinions_v aov

215: IS
216: SELECT count(1)
217: --FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id, aca.control_id
218: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
219: FROM amw_control_associations aca,amw_opinions_v aov
220: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
221: AND aca.pk1 = p_certification_id
222: AND aca.pk2 = p_org_id
223: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 253: FROM amw_control_associations aca,amw_opinions_v aov

249: CURSOR get_evaluated_controls
250: IS
251: SELECT count(1)
252: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
253: FROM amw_control_associations aca,amw_opinions_v aov
254: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
255: AND aca.pk1 = p_certification_id
256: AND aca.pk2 = p_org_id
257: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 280: FROM amw_control_associations aca

276: CURSOR get_total_controls
277: IS
278: SELECT count(1) from
279: (select DISTINCT aca.pk2 organization_id,aca.pk3 process_id, aca.control_id
280: FROM amw_control_associations aca
281: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
282: AND aca.pk1 = p_certification_id
283: AND aca.pk2 = p_org_id
284: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 957: FROM AMW_CONTROL_ASSOCIATIONS aca,

953: CURSOR new_controls_added
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

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