81: IF p_subsidiary_id = -1 THEN
82: RETURN;
83: END IF;
84:
85: MERGE INTO amw_org_cert_aggr_sum sum_tab
86: USING
87: (SELECT nvl(SUM(nvl(SUB_ORG_CERT,0)),0) SUB_ORG_CERT,
88: nvl(SUM(nvl(TOTAL_SUB_ORG,0)),0) TOTAL_SUB_ORG,
89: nvl(SUM(nvl(PROCESSES_CERTIFIED,0)),0) PROCESSES_CERTIFIED,
234: unmitigated_risks_prcnt,
235: ineff_controls_prcnt
236: )
237: VALUES
238: (amw_org_cert_aggr_sum_s.nextval,
239: p_certification_id,
240: 'SUBSIDIARY',
241: p_subsidiary_id,
242: sum_query.sub_org_cert,