APPS.WF_MAINTENANCE dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 43: from WF_ITEM_ACTIVITY_STATUSES_H

39: where ASSIGNED_USER = l_oldname;
40:
41: cursor ItemActivityStatuses_H (l_oldname varchar2) is
42: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
43: from WF_ITEM_ACTIVITY_STATUSES_H
44: where ASSIGNED_USER = l_oldname;
45:
46: cursor Notifications (l_oldname varchar2) is
47: select NOTIFICATION_ID

Line 148: update WF_ITEM_ACTIVITY_STATUSES_H

144: end loop;
145:
146: for IASH in ItemActivityStatuses_H (l_oldname) loop
147:
148: update WF_ITEM_ACTIVITY_STATUSES_H
149: set ASSIGNED_USER = l_newname
150: where ITEM_TYPE = iash.item_type
151: and ITEM_KEY = iash.item_key
152: and PROCESS_ACTIVITY = iash.process_activity;