951: AND ARC_ACT_METRIC_USED_BY = 'FUND';
952:
953: DELETE FROM ozf_act_metric_form_ent
954: WHERE formula_id IN ( SELECT FORMULA_ID
955: FROM OZF_ACT_METRIC_FORMULAS
956: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id);
957:
958: DELETE FROM ozf_act_metric_formulas
959: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;
954: WHERE formula_id IN ( SELECT FORMULA_ID
955: FROM OZF_ACT_METRIC_FORMULAS
956: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id);
957:
958: DELETE FROM ozf_act_metric_formulas
959: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;
960:
961: DELETE from ozf_act_metrics_all
962: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;