DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on OZF_ACT_METRICS_ALL

Line 778: from ozf_act_metrics_all

774: OR (component_id = p_object_id AND component_type = 'FUND');
775:
776: CURSOR c_get_metrics IS
777: SELECT activity_metric_id
778: from ozf_act_metrics_all
779: where act_metric_used_by_id = p_object_id
780: and arc_act_metric_used_by = 'FUND';
781:
782: CURSOR c_fund_access IS

Line 938: DELETE from ozf_act_metrics_all

934:
935: DELETE FROM ozf_act_metric_formulas
936: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;
937:
938: DELETE from ozf_act_metrics_all
939: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;
940: END LOOP;
941:
942: -- delete transaction data