APPS.WF_NTF_RULE dependencies on WF_MESSAGE_ATTRIBUTES

Line 85: and exists (select null from wf_message_attributes wma

81: and wnr.status = 'ENABLED'
82: and wnrc.message_type = p_message_type
83: and ((p_customization_level is null and wnr.customization_level <> 'C')
84: or wnr.customization_level = p_customization_level)
85: and exists (select null from wf_message_attributes wma
86: where wma.message_type = p_message_type
87: and (wma.message_name = p_message_name or p_message_name is null)
88: and wma.name = wnrm.attribute_name)
89: order by wnrm.column_name, wnr.phase desc;

Line 93: from wf_message_attributes_tl

89: order by wnrm.column_name, wnr.phase desc;
90:
91: cursor mesg_attr1(aname varchar2) is
92: select display_name
93: from wf_message_attributes_tl
94: where message_type = p_message_type
95: and message_name = p_message_name
96: and name = aname
97: and language = userenv('LANG');

Line 101: from wf_message_attributes_tl

97: and language = userenv('LANG');
98:
99: cursor mesg_attr_all(aname varchar2) is
100: select distinct display_name
101: from wf_message_attributes_tl
102: where message_type = p_message_type
103: and name = aname
104: and language = userenv('LANG');
105: