APPS.WF_NTFRULE_UTIL SQL Statements

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

Line: 18

   select distinct display_name from wf_message_attributes_vl where
   name = attributeName and type = attributeType and
   message_type in (select message_type from wf_ntf_rule_criteria where rule_name = ruleName);

Line: 67

   select distinct display_name from wf_message_attributes_vl where
   name = attributeName and type = attributeType and
   message_type = messageType;

Line: 130

  query_stmt := 'select distinct display_name, name from wf_messages_vl '||
  		 'where ' ||
		 '(name,type) in '||
     		 '(select message_name, message_type from wf_message_attributes_vl '||
      		 'where '||
      		 'name = :1 and '||
      		 'display_name = :2 and '||
                 'type = :3 and '||
                 'message_type in ('||messageTypes||'))';