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_ORG_PROC_CERT_DATED_SUMM dependencies on AMW_CONTROL_ASSOCIATIONS

Line 214: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

210: CURSOR get_eval_controls
211: IS
212: SELECT count(1)
213: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
214: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
215: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
216: AND acb.control_rev_id = aca.control_rev_id
217: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
218: AND aca.pk1 = p_certification_id

Line 254: FROM amw_control_associations aca, amw_controls_b acb

250: CURSOR get_total_controls
251: IS
252: SELECT count(1)
253: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
254: FROM amw_control_associations aca, amw_controls_b acb
255: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
256: AND acb.control_rev_id = aca.control_rev_id
257: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
258: AND aca.pk1 = p_certification_id

Line 283: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

279: CURSOR get_ineff_controls
280: IS
281: SELECT count(1)
282: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
283: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
284: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
285: AND acb.control_rev_id = aca.control_rev_id
286: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
287: AND aca.pk1 = p_certification_id

Line 324: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

320: CURSOR get_ineff_controls
321: IS
322: SELECT count(1)
323: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
324: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
325: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
326: AND acb.control_rev_id = aca.control_rev_id
327: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
328: AND aca.pk1 = p_certification_id

Line 347: FROM amw_control_associations aca, amw_controls_b acb

343: CURSOR get_total_controls
344: IS
345: SELECT count(1)
346: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
347: FROM amw_control_associations aca, amw_controls_b acb
348: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
349: AND acb.control_rev_id = aca.control_rev_id
350: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
351: AND aca.pk1 = p_certification_id

Line 510: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

506: CURSOR get_ineff_controls
507: IS
508: SELECT count(1)
509: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
510: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
511: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
512: AND acb.control_rev_id = aca.control_rev_id
513: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
514: AND aca.pk1 = p_certification_id

Line 565: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

561: CURSOR get_eval_controls
562: IS
563: SELECT count(1)
564: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
565: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
566: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
567: AND acb.control_rev_id = aca.control_rev_id
568: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
569: AND aca.pk1 = p_certification_id

Line 616: FROM amw_control_associations aca, amw_controls_b acb

612: CURSOR get_total_controls
613: IS
614: SELECT count(1)
615: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
616: FROM amw_control_associations aca, amw_controls_b acb
617: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
618: AND acb.control_rev_id = aca.control_rev_id
619: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
620: AND aca.pk1 = p_certification_id

Line 656: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

652: CURSOR get_ineff_controls
653: IS
654: SELECT count(1)
655: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
656: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
657: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
658: AND acb.control_rev_id = aca.control_rev_id
659: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
660: AND aca.pk1 = p_certification_id

Line 690: FROM amw_control_associations aca, amw_controls_b acb

686: CURSOR get_total_controls
687: IS
688: SELECT count(1)
689: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
690: FROM amw_control_associations aca, amw_controls_b acb
691: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
692: AND acb.control_rev_id = aca.control_rev_id
693: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
694: AND aca.pk1 = p_certification_id