APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSD_DP_SCN_ENTRIES_DENORM

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

314: END IF;
315:
316: COMMIT;
317:
318: lv_sql_stmt2 := 'DELETE FROM MSD_DP_SCN_ENTRIES_DENORM ' || 'WHERE SCENARIO_ID = :l_scenario_id ' || 'AND DEMAND_PLAN_ID = 5555555';
319:
320: EXECUTE IMMEDIATE lv_sql_stmt2 USING l_scenario_id;
321:
322: INSERT

Line 323: 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)

319:
320: EXECUTE IMMEDIATE lv_sql_stmt2 USING l_scenario_id;
321:
322: INSERT
323: 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)
324: (SELECT mdse.demand_plan_id,
325: mdse.scenario_id,
326: mdse.entry_id,
327: msi.sr_inventory_item_id,