APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_ACT_FORECASTS_ALL
Line 1141: FROM ozf_act_forecasts_all fore, ozf_act_metric_facts_all metr
1137: CURSOR l_forecast_csr (p_offer_id IN NUMBER) IS
1138: SELECT DISTINCT metr.from_date -- need distince for multiple dimension forecast
1139: ,metr.TO_DATE
1140: ,metr.fact_percent 1141: FROM ozf_act_forecasts_all fore, ozf_act_metric_facts_all metr 1142: WHERE fore.arc_act_fcast_used_by = 'OFFR'
1143: AND fore.act_fcast_used_by_id = p_offer_id
1144: AND fore.base_quantity_type <>'BASELINE'
1145: AND metr.arc_act_metric_used_by = 'FCST'