DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_MESSAGE_ATTRIBUTES

Line 167: from wf_message_attributes ma

163: from WF_ROUTING_RULE_ATTRIBUTES ra
164: where ra.TEXT_VALUE = l_oldname
165: and exists
166: (select null
167: from wf_message_attributes ma
168: where ma.name=ra.name
169: and ma.type='ROLE');
170:
171: cursor cWfComments (l_oldname varchar2) is

Line 2130: from WF_MESSAGE_ATTRIBUTES ma

2126: where wrr.RULE_ID=ra.RULE_ID
2127: and ra.TEXT_VALUE = p_name
2128: and exists
2129: (select '1'
2130: from WF_MESSAGE_ATTRIBUTES ma
2131: where ma.NAME=ra.NAME
2132: and ma.TYPE='ROLE');
2133: else
2134: l_wfcount_tab.REC_CNT := 0;

Line 2146: from WF_MESSAGE_ATTRIBUTES ma

2142: and wrr.RULE_ID=ra.RULE_ID
2143: and ra.TEXT_VALUE = p_name
2144: and exists
2145: (select '1'
2146: from WF_MESSAGE_ATTRIBUTES ma
2147: where ma.NAME=ra.NAME
2148: and ma.TYPE='ROLE');
2149: else
2150: l_wfcount_tab.REC_CNT := 0;