DBA Data[Home] [Help]

APPS.MSD_COPY_DEMAND_PLAN dependencies on MSD_DP_FORMULAS

Line 65: from msd_dp_formulas

61: where demand_plan_id = p_source_demand_plan_id;
62:
63: cursor cur_formula is
64: select formula_id
65: from msd_dp_formulas
66: where demand_plan_id = p_source_demand_plan_id
67: and (nvl(supply_plan_flag,'N') = 'N'
68: or p_source_demand_plan_id not in
69: (select demand_plan_id

Line 922: INSERT INTO msd_dp_formulas

918: select msd_dp_parameters_s.nextval into x_new_formula_id
919: from dual;
920:
921:
922: INSERT INTO msd_dp_formulas
923: ( DEMAND_PLAN_ID
924: ,FORMULA_ID
925: ,CREATION_SEQUENCE
926: ,FORMULA_NAME

Line 984: msd_dp_formulas mdf

980: ,SYSDATE
981: ,UPLOAD_FORMULA_ID
982: ,START_PERIOD /*----NEW COLUMN ADDED--BUG#4744717-----*/
983: FROM
984: msd_dp_formulas mdf
985: WHERE
986: formula_id = lv_cur_formula_rec.formula_id AND demand_plan_id =
987: p_source_demand_plan_id;
988: