APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_LEVELS

Line 2448: (select level_id from msd_levels

2444: where demand_plan_id = p_new_dp_id
2445:
2446: and level_id in
2447:
2448: (select level_id from msd_levels
2449:
2450: where dimension_code = p_dimension_code
2451:
2452: and nvl(plan_type,'DP') = decode(p_plan_type,null,'DP','SOP','DP','EOL','DP',p_plan_type))

Line 2512: from msd_levels

2508: -- check if the seeded level exists or has been removed
2509:
2510: select count(*) into l_count
2511:
2512: from msd_levels
2513:
2514: where level_id = c2_cur.selection_value
2515:
2516: and nvl(plan_type,'DP') = decode(l_plan_type,null,'DP','SOP','DP','EOL','DP',l_plan_type);

Line 2954: (select distinct level_id from msd_levels

2950: or (selection_type = 'L'
2951:
2952: and selection_value in
2953:
2954: (select distinct level_id from msd_levels
2955:
2956: where dimension_code = p_dp_dimension_code)));
2957:
2958:

Line 3528: (select distinct level_id from msd_levels

3524: or (selection_type = 'L'
3525:
3526: and selection_value in
3527:
3528: (select distinct level_id from msd_levels
3529:
3530: where dimension_code = p_dp_dimension_code)));
3531:
3532:

Line 4142: from msd_levels

4138: cursor c2 is
4139:
4140: select dimension_code
4141:
4142: from msd_levels
4143:
4144: where level_id = p_level_id;
4145:
4146:

Line 7578: msd_levels ml

7574: msd_hierarchies mh,
7575:
7576: msd_hierarchy_levels mhl,
7577:
7578: msd_levels ml
7579:
7580: where mdd.dimension_code =
7581:
7582: (select dimension_code

Line 7602: ml.level_type_code = (select distinct level_type_code from msd_levels where level_id=p_level_id);

7598: mhl.hierarchy_id=mh.hierarchy_id and
7599:
7600: (mhl.level_id=ml.level_id or mhl.parent_level_id=ml.level_id) and
7601:
7602: ml.level_type_code = (select distinct level_type_code from msd_levels where level_id=p_level_id);
7603:
7604:
7605:
7606: cursor c_level_id(p_demand_plan_id number, p_level_id number) is