DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on OZF_ACT_METRICS_ALL

Line 782: from ozf_act_metrics_all

778: OR (component_id = p_object_id AND component_type = 'FUND');*/
779:
780: CURSOR c_get_metrics IS
781: SELECT activity_metric_id
782: from ozf_act_metrics_all
783: where act_metric_used_by_id = p_object_id
784: and arc_act_metric_used_by = 'FUND';
785:
786: CURSOR c_fund_access IS

Line 961: DELETE from ozf_act_metrics_all

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;
963: END LOOP;
964:
965: -- delete transaction data