APPS.MSD_LIABILITY dependencies on MSD_LEVELS

Line 1470: from msd_levels

1466:
1467: /* Get the Parent Level Type */
1468: begin
1469: select level_type_code into v_parent_lvl_type
1470: from msd_levels
1471: where level_id = p_parent_level_id
1472: and plan_type = 'LIABILITY' ;
1473:
1474: exception

Line 1894: from msd_st_level_associations_lb mla, msd_levels ml

1890: mla.plan_id,
1891: ml.level_type_code,
1892: mla.level_id,
1893: mla.parent_level_id
1894: from msd_st_level_associations_lb mla, msd_levels ml
1895: where mla.level_id = ml.level_id
1896: and ml.plan_type = 'LIABILITY'
1897: and mla.plan_id = p_plan_id ;
1898:

Line 2012: from msd_levels

2008:
2009: Delete from msd_st_level_values_lb
2010: where level_id in (
2011: select level_id
2012: from msd_levels
2013: where level_type_code = '1'
2014: and plan_type = 'LIABILITY') ;
2015:
2016:

Line 2235: msd_levels ml,

2231: CURSOR get_dup_dim_output_levels IS
2232: SELECT scen.scenario_name,ml.dimension_code,count(*)
2233: FROM
2234: msd_dp_scenario_output_levels a,
2235: msd_levels ml,
2236: msd_dp_scenarios scen,
2237: msd_demand_plans mdp
2238: WHERE a.level_id = ml.level_id
2239: AND a.scenario_id = scen.scenario_id