APPS.FND_WF_ENGINE SQL Statements

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

Line: 1075

     select count(1)
     into disable_or_launch
     from WF_ITEM_ACTIVITY_STATUSES WIAS,
          WF_NOTIFICATIONS WN,
          WF_NOTIFICATION_ATTRIBUTES NATTR
     where     WIAS.ITEM_TYPE = l_item_type
           and WIAS.ITEM_KEY  = l_itemkey
           and WIAS.PROCESS_ACTIVITY = c_instid
           and WIAS.NOTIFICATION_ID = WN.GROUP_ID
           and NATTR.NOTIFICATION_ID = WN.NOTIFICATION_ID
           and NATTR.NAME = l_name
           and WN.RECIPIENT_ROLE in
              (select WUR.ROLE_NAME
               from WF_USER_ROLES WUR
               where WUR.USER_NAME = l_username);

Line: 1091

     select count(1)
     into disable_or_launch
     from WF_ITEM_ACTIVITY_STATUSES WIAS,
          WF_NOTIFICATIONS WN,
          WF_NOTIFICATION_ATTRIBUTES NATTR
     where     WIAS.ITEM_TYPE = l_item_type
           and WIAS.ITEM_KEY  = l_itemkey
           and WIAS.PROCESS_ACTIVITY = c_instid
           and WIAS.NOTIFICATION_ID = WN.GROUP_ID
           and NATTR.NOTIFICATION_ID = WN.NOTIFICATION_ID
           and NATTR.NAME = l_name
           and WN.RECIPIENT_ROLE in
              (select WUR.ROLE_NAME
               from WF_USER_ROLES WUR
               where WUR.USER_ORIG_SYSTEM = substr(l_username, 1, colon-1)
               and WUR.USER_ORIG_SYSTEM_ID = substr(l_username, colon+1)
               and WUR.USER_NAME = l_username
               and WUR.USER_ORIG_SYSTEM not in
                     ('HZ_PARTY','CUST_CONT'));