APPS.CSI_COUNTER_PVT dependencies on CSI_COUNTER_USAGE_FORECAST

Line 2350: FROM CSI_COUNTER_USAGE_FORECAST

2346: IF l_counter_id IS NOT NULL THEN
2347: BEGIN
2348: SELECT max(active_start_date)
2349: INTO l_max_start_date
2350: FROM CSI_COUNTER_USAGE_FORECAST
2351: WHERE counter_id = l_counter_id;
2352:
2353: IF l_max_start_date IS NOT NULL THEN
2354: IF l_active_start_date < l_max_start_date THEN

Line 2388: UPDATE CSI_COUNTER_USAGE_FORECAST

2384: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INV_USE_PAST_RDG');
2385: end if;
2386:
2387: -- update to end date existing active usage rate
2388: UPDATE CSI_COUNTER_USAGE_FORECAST
2389: SET active_end_date = l_active_start_date
2390: -- SET active_end_date = sysdate
2391: WHERE instance_forecast_id in (select instance_forecast_id
2392: from CSI_COUNTER_USAGE_FORECAST

Line 2392: from CSI_COUNTER_USAGE_FORECAST

2388: UPDATE CSI_COUNTER_USAGE_FORECAST
2389: SET active_end_date = l_active_start_date
2390: -- SET active_end_date = sysdate
2391: WHERE instance_forecast_id in (select instance_forecast_id
2392: from CSI_COUNTER_USAGE_FORECAST
2393: where counter_id = l_counter_id
2394: and active_end_date is null);
2395:
2396: -- call table handler here