DBA Data[Home] [Help]

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) )