APPS.MSC_WS_ASCP dependencies on MSC_PLAN_SCHEDULES
Line 111: decode((select count(*) from msc_plan_schedules
107: INTO l_val_launchsnapshot
108: FROM mfg_lookups
109: WHERE lookup_type = 'MSC_LAUNCH_SNAPSHOT'
110: AND lookup_code in decode(lookup_code,1,1,2,2,3, 111: decode((select count(*) from msc_plan_schedules 112: where plan_id = planId
113: and rownum = 1
114: and designator_type = 7
115: and input_type = 1),0,1,3) )