APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on AS_INTERNAL_FORECASTS

Line 38: FROM as_internal_forecasts

34: l_forecast_id NUMBER := null;
35:
36: CURSOR get_forecasts (sg_id number, sf_id number) IS
37: SELECT forecast_id
38: FROM as_internal_forecasts
39: WHERE sales_group_id = sg_id
40: AND salesforce_id = sf_id
41: AND status_code = 'SUBMITTED'
42: AND end_date_active is null;

Line 240: UPDATE as_internal_forecasts

236: SET object_version_number = nvl(object_version_number,0) + 1, end_date_active = sysdate
237: WHERE forecast_id = l_forecast_id
238: AND end_date_active is null;
239:
240: UPDATE as_internal_forecasts
241: SET object_version_number = nvl(object_version_number,0) + 1, end_date_active = sysdate
242: WHERE forecast_id = l_forecast_id
243: AND end_date_active is null;
244: