APPS.WF_NTF_RULE SQL Statements

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

Line: 23

    select distinct wnrc.message_type
    from   wf_ntf_rules wnr,
           wf_ntf_rule_criteria wnrc
    where  wnr.rule_name = l_rule_name
    and    wnr.rule_name = wnrc.rule_name;

Line: 70

    select
          wnrm.column_name,
          wnr.phase,
          wnrm.attribute_name,
          wnr.customization_level,
          wnr.rule_name
     from wf_ntf_rules wnr,
          wf_ntf_rule_criteria wnrc,
          wf_ntf_rule_maps wnrm
    where wnr.rule_name = wnrc.rule_name
    and   wnr.rule_name = wnrm.rule_name
    and   wnr.status = 'ENABLED'
    and   wnrc.message_type = p_message_type
    and   ((p_customization_level is null and wnr.customization_level <> 'C')
          or wnr.customization_level = p_customization_level)
    and   exists (select null from wf_message_attributes wma
                  where wma.message_type = p_message_type
		  and  (wma.message_name = p_message_name or p_message_name is null)
		  and  wma.name = wnrm.attribute_name)
    order by wnrm.column_name, wnr.phase desc;

Line: 92

    select display_name
      from wf_message_attributes_tl
     where message_type = p_message_type
       and message_name = p_message_name
       and name = aname
       and language = userenv('LANG');

Line: 100

    select distinct display_name
      from wf_message_attributes_tl
     where message_type = p_message_type
       and name = aname
       and language = userenv('LANG');

Line: 109

   x_custom_col_tbl.delete;