APPS.MSD_FCST_PUB dependencies on MSD_HIERARCHY_LEVELS

Line 492: (select hierarchy_id from msd_hierarchy_levels where level_id = p_level_id

488: -- zia 4/12/01/ end
489:
490: select min(hierarchy_id) into hier
491: from
492: (select hierarchy_id from msd_hierarchy_levels where level_id = p_level_id
493: INTERSECT
494: select hierarchy_id from msd_hierarchy_levels where level_id = lvl);
495:
496: lvl2 := p_level_id;

Line 494: select hierarchy_id from msd_hierarchy_levels where level_id = lvl);

490: select min(hierarchy_id) into hier
491: from
492: (select hierarchy_id from msd_hierarchy_levels where level_id = p_level_id
493: INTERSECT
494: select hierarchy_id from msd_hierarchy_levels where level_id = lvl);
495:
496: lvl2 := p_level_id;
497: qstr := '(' || to_char(p_value_id) || ')';
498:

Line 502: from msd_hierarchy_levels

498:
499: while (lvl2 <> lvl) loop
500:
501: select level_id into lvl2
502: from msd_hierarchy_levels
503: where parent_level_id = lvl2
504: and hierarchy_id = hier;
505:
506: open lpks for 'select level_pk from msd_level_values_v ' ||