APPS.POR_NOTIFICATION_PKG SQL Statements

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

Line: 25

    select orig_system_id, orig_system
    from wf_users
    where name = user
    and orig_system not in ('POS', 'ENG_LIST', 'CUST_CONT');

Line: 31

  select WN.notification_id
  from WF_NOTIFICATIONS WN
  where WN.RECIPIENT_ROLE in
   ((select user from dual) union all
    (select role_name from wf_user_roles
     where user_name = user and
     user_orig_system = origSys and user_orig_system_id = origId ))
  and  wn.message_type in
   ( select distinct  WF_CREATEDOC_ITEMTYPE
     from PO_DOCUMENT_TYPES
     union
     select distinct  WF_APPROVAL_ITEMTYPE
     from PO_DOCUMENT_TYPES
     union
     select 'PORCPT' from dual)
  and wn.status = 'OPEN'
  and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,
    WF_MESSAGE_ATTRIBUTES_VL MA,
    WF_NOTIFICATIONS N
    where
     N.NOTIFICATION_ID=WN.NOTIFICATION_ID
     and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
     and MA.MESSAGE_NAME = N.MESSAGE_NAME
     and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
     and MA.NAME = NA.NAME
     and MA.SUBTYPE = 'RESPOND'
     and MA.TYPE <> 'FORM')
  and sysdate - wn.begin_date <=60
  order by WN.notification_id desc;