APPS.WFA_HTML_JSP SQL Statements

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

Line: 26

      select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
      into uorig_system, uorig_system_id
      from WF_ROLES WR
      where WR.NAME = username
      and   WR.ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
                                  'HZ_GROUP','CUST_CONT');

Line: 34

      select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
      into uorig_system, uorig_system_id
      from WF_ROLES WR
      where WR.ORIG_SYSTEM = substr(username, 1, colon-1)
      and WR.ORIG_SYSTEM_ID = substr(username,  colon+1)
      and WR.NAME = username;

Line: 49

  select MAX(notification_id) into nid
  from   (
         select notification_id, context
         from   WF_NOTIFICATIONS
         where  more_info_role = username
         union all
         select notification_id, context
         from   WF_NOTIFICATIONS
         where  more_info_role is null
         and    RECIPIENT_ROLE in
                (select WUR.ROLE_NAME
                 from   WF_USER_ROLES WUR
                 where  WUR.USER_ORIG_SYSTEM = getSSPNid.uorig_system
                 and    WUR.USER_ORIG_SYSTEM_ID = getSSPNid.uorig_system_id
                 and    WUR.USER_NAME = username)
         ) v
  where v.context like ctx;

Line: 98

      select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
      into uorig_system, uorig_system_id
      from WF_ROLES WR
      where WR.NAME = username
      and   WR.ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
                                  'HZ_GROUP','CUST_CONT');

Line: 106

      select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
      into uorig_system, uorig_system_id
      from WF_ROLES WR
      where WR.ORIG_SYSTEM = substr(username, 1, colon-1)
      and WR.ORIG_SYSTEM_ID = substr(username,  colon+1)
      and WR.NAME = username;

Line: 121

  select MAX(notification_id) into nid
  from   (
         select notification_id, context
         from   WF_NOTIFICATIONS
         where  more_info_role = username
         and    status = 'OPEN'
         union all
         select notification_id, context
         from   WF_NOTIFICATIONS
         where  more_info_role is null
         and    RECIPIENT_ROLE in
                (select WUR.ROLE_NAME
                 from   WF_USER_ROLES WUR
                 where  WUR.USER_ORIG_SYSTEM = getSSPOpenNid.uorig_system
                 and    WUR.USER_ORIG_SYSTEM_ID = getSSPOpenNid.uorig_system_id
                 and    WUR.USER_NAME = username)
         and    status = 'OPEN'
         ) v
  where v.context like ctx;