APPS.MSC_WS_SNO dependencies on MSC_PLANS

Line 32: FROM MSC_PLANS

28:
29: -- check the plan
30: BEGIN
31: SELECT COMPILE_DESIGNATOR INTO l_PlanName
32: FROM MSC_PLANS
33: WHERE PLAN_ID = planId and PLAN_TYPE = 6;
34: EXCEPTION WHEN no_data_found THEN
35: processId := -1;
36: status := 'INVALID_PLANID';

Line 149: FROM MSC_PLANS

145:
146: -- check the plan
147: BEGIN
148: SELECT COMPILE_DESIGNATOR INTO l_PlanName
149: FROM MSC_PLANS
150: WHERE PLAN_ID = planId and PLAN_TYPE = 6;
151: EXCEPTION WHEN no_data_found THEN
152: processId := -1;
153: status := 'INVALID_PLANID';