DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_DEMAND_PLANS

Line 1412: FROM msd_demand_plans;

1408: BEGIN
1409:
1410: /* Find the least refresh number for existing demand plan */
1411: SELECT nvl(min(dp_build_refresh_num), 0) INTO l_least_refresh_num
1412: FROM msd_demand_plans;
1413:
1414: if l_least_refresh_num <> 0 then
1415: DELETE FROM msd_deleted_level_values
1416: WHERE LAST_REFRESH_NUM <= l_least_refresh_num;