APPS.MSC_WS_SNO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

       SELECT COMPILE_DESIGNATOR INTO l_PlanName
       FROM MSC_PLANS
       WHERE PLAN_ID = planId and PLAN_TYPE = 6;

Line: 148

       SELECT COMPILE_DESIGNATOR INTO l_PlanName
       FROM MSC_PLANS
       WHERE PLAN_ID = planId and PLAN_TYPE = 6;