APPS.MSC_SCN_ACTIVITY_WF SQL Statements

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

Line: 20

SELECT MSA.ACTIVITY_NAME, MSA.FINISH_BY, MSA.PRIORITY, MSA.STATUS, MSA.OWNER, MSA.ALTERNATE_OWNER,
  MSA.ACT_COMMENT,
  MS.SCENARIO_NAME, MSS.SCENARIO_SET_NAME
  FROM MSC_SCENARIO_ACTIVITIES MSA,
    MSC_SCENARIOS MS,
    MSC_SCENARIO_SETS MSS
WHERE
    ACTIVITY_ID= p_activity_id
    AND MSA.SCENARIO_ID=MS.SCENARIO_ID(+)
    AND MSA.SCENARIO_SET_ID=MSS.SCENARIO_SET_ID(+);

Line: 60

        select MSC_FORM_QUERY_S.nextval into l_itemkey from dual;

Line: 62

        select user_name into l_itemowner from fnd_user where user_id=userId; --WF owner

Line: 72

          select user_name into l_owner_name from fnd_user where user_id = l_owner;

Line: 73

          select user_name into l_alt_owner_name from fnd_user where user_id = l_alternate_owner;

Line: 74

          select meaning into l_status_name from mfg_lookups where lookup_type like 'MSC_SCN_ACTIVITY_STATES' and lookup_code=l_status;

Line: 135

    SELECT MSA.ACTIVITY_ID    , MSA.ACTIVITY_NAME,
           MSA.FINISH_BY      , MSA.PRIORITY     ,
           MSA.STATUS         , MSA.OWNER        ,
           MSA.ALTERNATE_OWNER, MSA.ACT_COMMENT  ,
           MS.SCENARIO_NAME   , MSS.SCENARIO_SET_NAME
    FROM MSC_SCENARIO_ACTIVITIES MSA,
         MSC_SCENARIOS MS,
         MSC_SCENARIO_SETS MSS
    WHERE MSA.STATUS IN (1,2) -- 1 Not Started , 2 In Progress
    AND   MSA.FINISH_BY < TRUNC(SYSDATE)
    AND   MSA.SCENARIO_ID=MS.SCENARIO_ID(+)
    AND   MSA.SCENARIO_SET_ID=MSS.SCENARIO_SET_ID(+);