APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSD_DP_SCN_ENTRIES_DENORM

Line 325: lv_sql_stmt2 := 'DELETE FROM MSD_DP_SCN_ENTRIES_DENORM ' || 'WHERE SCENARIO_ID = :l_scenario_id ' || 'AND DEMAND_PLAN_ID = 5555555';

321: END IF;
322:
323: COMMIT;
324:
325: lv_sql_stmt2 := 'DELETE FROM MSD_DP_SCN_ENTRIES_DENORM ' || 'WHERE SCENARIO_ID = :l_scenario_id ' || 'AND DEMAND_PLAN_ID = 5555555';
326:
327: EXECUTE IMMEDIATE lv_sql_stmt2 USING l_scenario_id;
328:
329: INSERT

Line 330: INTO msd_dp_scn_entries_denorm(demand_plan_id, scenario_id, demand_id, sr_inventory_item_id, sr_organization_id, start_time, end_time, quantity, creation_date, created_by)

326:
327: EXECUTE IMMEDIATE lv_sql_stmt2 USING l_scenario_id;
328:
329: INSERT
330: INTO msd_dp_scn_entries_denorm(demand_plan_id, scenario_id, demand_id, sr_inventory_item_id, sr_organization_id, start_time, end_time, quantity, creation_date, created_by)
331: (SELECT mdse.demand_plan_id,
332: mdse.scenario_id,
333: mdse.entry_id,
334: msi.sr_inventory_item_id,