DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_DEMAND_PLANS

Line 1444: FROM msd_demand_plans;

1440: BEGIN
1441:
1442: /* Find the least refresh number for existing demand plan */
1443: SELECT nvl(min(dp_build_refresh_num), 0) INTO l_least_refresh_num
1444: FROM msd_demand_plans;
1445:
1446: if l_least_refresh_num <> 0 then
1447: DELETE FROM msd_deleted_level_values
1448: WHERE LAST_REFRESH_NUM <= l_least_refresh_num;