APPS.WF_MAINTENANCE dependencies on WF_ITEM_ATTRIBUTES

Line 202: from wf_item_attribute_values wiav, wf_item_attributes wia

198: and WI.END_DATE IS NULL));
199:
200: cursor cRoleAttributes (l_oldname varchar2) is
201: select wiav.rowid
202: from wf_item_attribute_values wiav, wf_item_attributes wia
203: where wia.type = 'ROLE'
204: and wia.item_type = wiav.item_type
205: and wia.name = wiav.name
206: and wiav.text_value = l_oldname;

Line 210: from wf_item_attribute_values wiav, wf_item_attributes wia

206: and wiav.text_value = l_oldname;
207:
208: cursor cRoleAttributes2 (l_oldname varchar2) is
209: select wiav.rowid
210: from wf_item_attribute_values wiav, wf_item_attributes wia
211: where wia.type = 'ROLE'
212: and wia.item_type = wiav.item_type
213: and wia.name = wiav.name
214: and wiav.text_value = l_oldname

Line 2197: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA

2193:
2194: -- Determine rows to change in WF_ITEM_ATTRIBUTE_VALUES. Can be any role.
2195: if (l_pvalue is null or l_pvalue = 'Y') then
2196: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2197: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA
2198: where WIA.type = 'ROLE'
2199: and WIA.ITEM_TYPE = WIAV.ITEM_TYPE
2200: and WIA.NAME = WIAV.NAME
2201: and WIAV.TEXT_VALUE = p_name;

Line 2204: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA

2200: and WIA.NAME = WIAV.NAME
2201: and WIAV.TEXT_VALUE = p_name;
2202: else
2203: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2204: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA
2205: where WIA.type = 'ROLE'
2206: and WIA.ITEM_TYPE = WIAV.ITEM_TYPE
2207: and WIA.NAME = WIAV.NAME
2208: and WIAV.TEXT_VALUE = p_name