APPS.WF_MAINTENANCE dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 76: from wf_item_attribute_values wiav, wf_item_attributes wia

72: or proxy_role = l_oldname;
73:
74: cursor roleAttributes (l_oldname varchar2) is
75: select wiav.rowid
76: from wf_item_attribute_values wiav, wf_item_attributes wia
77: where wia.type = 'ROLE'
78: and wia.item_type = wiav.item_type
79: and wia.name = wiav.name
80: and wiav.text_value = l_oldname;

Line 237: update WF_ITEM_ATTRIBUTE_VALUES

233: PerformCommit();
234: end loop;
235:
236: for rAttr in roleAttributes (l_oldname) loop
237: update WF_ITEM_ATTRIBUTE_VALUES
238: set TEXT_VALUE = l_newname
239: where rowid = rAttr.rowid;
240:
241: PerformCommit();