APPS.WF_NTFRULE_UTIL dependencies on WF_MESSAGE_ATTRIBUTES_VL

Line 18: select distinct display_name from wf_message_attributes_vl where

14: displayName VARCHAR2(32000);
15: cnt INTEGER := 1;
16:
17: cursor ntfrule_cursor is
18: select distinct display_name from wf_message_attributes_vl where
19: name = attributeName and type = attributeType and
20: message_type in (select message_type from wf_ntf_rule_criteria where rule_name = ruleName);
21:
22: Begin

Line 67: select distinct display_name from wf_message_attributes_vl where

63: displayName VARCHAR2(32000);
64: cnt INTEGER := 1;
65:
66: cursor ntfrule_cursor is
67: select distinct display_name from wf_message_attributes_vl where
68: name = attributeName and type = attributeType and
69: message_type = messageType;
70:
71: Begin

Line 133: '(select message_name, message_type from wf_message_attributes_vl '||

129:
130: query_stmt := 'select distinct display_name, name from wf_messages_vl '||
131: 'where ' ||
132: '(name,type) in '||
133: '(select message_name, message_type from wf_message_attributes_vl '||
134: 'where '||
135: 'name = :1 and '||
136: 'display_name = :2 and '||
137: 'type = :3 and '||