APPS.MSC_WS_NOTIFICATION_BPEL SQL Statements

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

Line: 22

    select count(*)
    into n_ctr
    from wf_local_roles
    where name = v_role_email;

Line: 84

        select MSC_FORM_QUERY_S.nextval into l_itemkey from dual;

Line: 86

        select email_address into v_email from fnd_user where user_name = receiver;

Line: 138

   select meaning  into actType
   from mfg_lookups
   where lookup_type = 'MSC_PROCESS_ACTIVITY_TYPES'
   and lookup_code = to_number(actTypeId);

Line: 171

   select COMPILE_DESIGNATOR
   into planName
   from msc_plans
   where plan_id = to_number(planId);

Line: 206

   select meaning  into escLevel
   from mfg_lookups
   where lookup_type = 'MSC_ESCALATION_LEVEL'
   and lookup_code = to_number(escId);