APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_WEB_SERVICES

Line 2304: select count(*) from msc_web_services where

2300:
2301: --return >0 if the current plan is already attached to any ws or if there is atleast one free ws available.
2302: -- also if the plan is currently in progress
2303: cursor c_ws_status (var_plan_id in number) is
2304: select count(*) from msc_web_services where
2305: plan_id in (-1, var_plan_id)
2306: and not exists (
2307: select 1 from msc_plans where status>0 and status <=50 and plan_id =var_plan_id
2308: );