APPS.MSD_PULL_LEVEL_VALUES dependencies on MSD_LEVELS

Line 54: from msd_st_level_associations mla, msd_levels ml

50: mla.instance,
51: ml.level_type_code,
52: mla.level_id,
53: mla.parent_level_id
54: from msd_st_level_associations mla, msd_levels ml
55: where mla.level_id = ml.level_id AND
56: mla.instance <> '0'
57: and ml.plan_type is null --vinekuma
58: /* Bug no 3799518. Enable load of level_org_asscns in legacy load as stand alone */

Line 66: msd_levels ml

62: ml.level_type_code,
63: mla.level_id,
64: mla.parent_level_id
65: from msd_level_associations mla,
66: msd_levels ml
67: where mla.level_id = ml.level_id
68: and ml.plan_type is null --vinekuma
69: and exists (select 1
70: from msd_st_level_org_asscns mlo

Line 83: from msd_st_level_associations mla, msd_levels ml

79: select distinct
80: mla.instance,
81: mla.level_id,
82: ml.level_type_code
83: from msd_st_level_associations mla, msd_levels ml
84: where mla.level_id = ml.level_id AND
85: mla.instance <> '0' AND
86: ml.plan_type is null --vinekuma
87:

Line 223: from msd_levels

219:
220: Delete from msd_st_level_values
221: where level_id in (
222: select level_id
223: from msd_levels
224: where level_type_code = '1'
225: and plan_type is null) ; --vinekuma
226:
227: