APPS.MSD_PULL_LEVEL_VALUES dependencies on MSD_ST_LEVEL_ASSOCIATIONS

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 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 147: Delete from msd_st_level_associations

143: ins('RETCODE ' || retcode || ' ' || Relationship_Rec.level_id || ' ' ||
144: Relationship_Rec.parent_level_id);
145: if (nvl(retcode,0) = 0 ) then
146:
147: Delete from msd_st_level_associations
148: where instance = Relationship_Rec.instance
149: and level_id = Relationship_Rec.level_id
150: and parent_level_id = Relationship_Rec.parent_level_id ;
151:

Line 193: Delete from msd_st_level_associations

189: Delete from msd_st_level_values
190: where instance = Relationship_Rec.instance
191: and level_id = Relationship_Rec.level_id ;
192:
193: Delete from msd_st_level_associations
194: where instance = Relationship_Rec.instance
195: and level_id = Relationship_Rec.level_id
196: and parent_level_id = Relationship_Rec.parent_level_id ;
197: