410: **/
411: SELECT decode(count(aca.control_id),0,'N','Y')
412: into l_key_control
413: FROM amw_control_associations aca
414: ,amw_controls_b acb
415: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
416: AND aca.pk1 = r_load_cols.certification_id
417: AND aca.pk2 = r_load_cols.organization_id
418: AND aca.pk3 IN (SELECT DISTINCT process_id
672: **/
673: SELECT decode(count(aca.control_id),0,'N','Y')
674: into l_key_control
675: FROM amw_control_associations aca
676: ,amw_controls_b acb
677: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
678: AND aca.pk1 = r_load_cols.certification_id
679: AND aca.pk2 = r_load_cols.organization_id
680: AND aca.pk3 IN (SELECT DISTINCT process_id
957: **/
958: SELECT decode(count(aca.control_id),0,'N','Y')
959: into l_key_control
960: FROM amw_control_associations aca
961: ,amw_controls_b acb
962: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
963: AND aca.pk1 = r_load_cols.certification_id
964: AND aca.pk2 = r_load_cols.organization_id
965: AND aca.pk3 IN (SELECT DISTINCT process_id
1196: **/
1197: SELECT decode(count(aca.control_id),0,'N','Y')
1198: into l_key_control
1199: FROM amw_control_associations aca
1200: ,amw_controls_b acb
1201: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
1202: AND aca.pk1 = r_load_cols.certification_id
1203: AND aca.pk2 = r_load_cols.organization_id
1204: AND aca.pk3 IN (SELECT DISTINCT process_id