APPS.WFA_HTML_UTIL SQL Statements

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

Line: 152

  select WL.MEANING
  into meaning
  from WF_LOOKUPS WL
  where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
  and WL.LOOKUP_CODE = GetLookupMeaning.lcode;

Line: 201

  select text_value
  into buf
  from WF_NOTIFICATION_ATTRIBUTES NA,
       WF_MESSAGE_ATTRIBUTES_VL MA,
       WF_NOTIFICATIONS N
  where N.NOTIFICATION_ID = nid
  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 = 'URL'
  and ROWNUM = 1;

Line: 299

    select FROM_USER, TO_USER, SUBJECT
      into from_user, to_user, subject
      from WF_NOTIFICATIONS
     where NOTIFICATION_ID = nid;