APPS.MSD_COMMON_UTILITIES_LB dependencies on MSC_PLANS

Line 171: from msc_plans

167: IS
168: CURSOR c_plan_start_date
169: is
170: select start_date
171: from msc_plans
172: where
173: plan_id = p_plan_id ;
174:
175: x_plan_start_date DATE ;

Line 196: from msc_plans

192: IS
193: CURSOR c_plan_end_date
194: is
195: select cutoff_date
196: from msc_plans
197: where
198: plan_id = p_plan_id ;
199:
200: x_plan_end_date DATE ;

Line 217: from msc_plans

213: IS
214: CURSOR c_plan_name
215: is
216: select compile_designator
217: from msc_plans
218: where
219: plan_id = p_plan_id ;
220:
221: x_plan_name VARCHAR2( 100) ;

Line 309: msc_plans mp

305: is
306: select md.organization_id
307: from
308: msc_designators md,
309: msc_plans mp
310: where
311: md.designator = mp.compile_designator
312: and mp.plan_id = p_plan_id ;
313:

Line 338: msc_plans mp

334: is
335: select md.sr_instance_id
336: from
337: msc_designators md ,
338: msc_plans mp
339: where
340: md.designator = mp.compile_designator
341: and mp.plan_id = p_plan_id ;
342: