APPS.MSD_PURGE dependencies on MSD_DP_SCENARIO_REVISIONS

Line 691: from msd_dp_scenario_revisions

687:
688: IF p_revision is not null THEN
689:
690: SELECt nvl(max(revision), -999) into l_latest_revision
691: from msd_dp_scenario_revisions
692: where demand_plan_id = p_demand_plan_id and
693: scenario_id = p_scenario_id;
694:
695: IF (p_revision = l_latest_revision) THEN

Line 710: l_delete_from := 'delete from msd_dp_scenario_revisions';

706: l_where := l_where || ' and revision = nvl(''' || p_revision || ''',revision)' ;
707: l_final_str := l_delete_from || l_where;
708: EXECUTE IMMEDIATE l_final_str;
709:
710: l_delete_from := 'delete from msd_dp_scenario_revisions';
711: l_where := ' where demand_plan_id = nvl(''' || p_demand_plan_id || ''',demand_plan_id)' ;
712: l_where := l_where || ' and scenario_id = nvl(''' || p_scenario_id || ''',scenario_id)' ;
713: l_where := l_where || ' and revision = nvl(''' || p_revision || ''',revision)' ;
714: l_final_str := l_delete_from || l_where;