APPS.MSD_ROLL_DEMAND_PLAN dependencies on MSD_DP_SCENARIO_REVISIONS

Line 32: lv_forecast_name MSD_DP_SCENARIO_REVISIONS.REVISION_NAME%TYPE;

28: lv_input_scenario_id IN NUMBER,
29: p_period_type IN NUMBER,
30: p_number_of_periods IN NUMBER ) AS
31:
32: lv_forecast_name MSD_DP_SCENARIO_REVISIONS.REVISION_NAME%TYPE;
33:
34: -- This cursor is used to select the latest forecast version for the dynamic parameter of type input scenario.
35: CURSOR latest_forecast_version IS
36: SELECT revision_name

Line 37: FROM msd_dp_scenario_revisions

33:
34: -- This cursor is used to select the latest forecast version for the dynamic parameter of type input scenario.
35: CURSOR latest_forecast_version IS
36: SELECT revision_name
37: FROM msd_dp_scenario_revisions
38: WHERE scenario_id = lv_input_scenario_id
39: AND demand_plan_id = lv_input_demand_plan_id
40: AND revision = (SELECT MAX (TO_NUMBER(revision))
41: FROM msd_dp_scenario_revisions

Line 41: FROM msd_dp_scenario_revisions

37: FROM msd_dp_scenario_revisions
38: WHERE scenario_id = lv_input_scenario_id
39: AND demand_plan_id = lv_input_demand_plan_id
40: AND revision = (SELECT MAX (TO_NUMBER(revision))
41: FROM msd_dp_scenario_revisions
42: WHERE scenario_id = lv_input_scenario_id
43: AND demand_plan_id = lv_input_demand_plan_id)
44: FOR UPDATE;
45: