APPS.WF_NOTIFICATION_UTIL SQL Statements

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

Line: 33

    update WF_NOTIFICATION_ATTRIBUTES
    set    EVENT_VALUE = avalue
    where  NOTIFICATION_ID = nid and NAME = aname;

Line: 70

      select WNA.EVENT_VALUE
      into   lvalue
      from   WF_NOTIFICATION_ATTRIBUTES WNA
      where  WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;

Line: 255

     SELECT value INTO  p_nlsNumericCharacters
     from v$nls_parameters
     where parameter = 'NLS_NUMERIC_CHARACTERS';

Line: 446

       select installed_flag
       into l_installed_flag
       from wf_languages
       where nls_language = p_language
       and installed_flag = 'Y';