APPS.MSD_COMMON_UTILITIES_LB dependencies on MSC_DESIGNATORS

Line 308: msc_designators md,

304: CURSOR c_plan_owning_org
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 ;

Line 337: msc_designators md ,

333: CURSOR c_plan_owning_instance
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 ;