APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_HIERARCHIES

Line 2462: from msd_dp_hierarchies

2458: cursor c5(p_plan_type in varchar2, p_dimension_code in varchar2) is
2459:
2460: select hierarchy_id
2461:
2462: from msd_dp_hierarchies
2463:
2464: where demand_plan_id = p_new_dp_id
2465:
2466: and hierarchy_id in

Line 4152: from msd_dp_hierarchies

4148: cursor c3(p_dimension_code in varchar2) is
4149:
4150: select distinct hierarchy_id
4151:
4152: from msd_dp_hierarchies
4153:
4154: where demand_plan_id = p_demand_plan_id
4155:
4156: and dp_dimension_code = p_dimension_code;

Line 4646: from msd_dp_hierarchies

4642: cursor c1 is
4643:
4644: select enable_nonseed_flag
4645:
4646: from msd_dp_hierarchies
4647:
4648: where demand_plan_id = p_demand_plan_id
4649:
4650: and hierarchy_id = p_old_hierarchy_id;

Line 7476: msd_dp_hierarchies mdh,

7472: select min(mdh.hierarchy_id)
7473:
7474: from msd_dp_dimensions mdd,
7475:
7476: msd_dp_hierarchies mdh,
7477:
7478: msd_hierarchies mh
7479:
7480: where mdd.dimension_code =

Line 7504: from msd_dp_hierarchies mdh

7500: cursor c_hierarchy_id(p_demand_plan_id number, p_hierarchy_id number) is
7501:
7502: select count(mdh.hierarchy_id)
7503:
7504: from msd_dp_hierarchies mdh
7505:
7506: where
7507:
7508: mdh.demand_plan_id=p_demand_plan_id and

Line 7572: msd_dp_hierarchies mdh,

7568: select min(ml.level_id)
7569:
7570: from msd_dp_dimensions mdd,
7571:
7572: msd_dp_hierarchies mdh,
7573:
7574: msd_hierarchies mh,
7575:
7576: msd_hierarchy_levels mhl,

Line 7610: from msd_dp_hierarchies mdh,

7606: cursor c_level_id(p_demand_plan_id number, p_level_id number) is
7607:
7608: select count(mdh.hierarchy_id)
7609:
7610: from msd_dp_hierarchies mdh,
7611:
7612: msd_hierarchy_levels mhl
7613:
7614: where