APPS.FND_WF_EVENT dependencies on WF_ITEM_ACTIVITY_STATUSES
Line 21: from wf_item_activity_statuses
17:
18: /* cursor to get most recent activity */
19: cursor curact(itype varchar2, ikey varchar2) is
20: select nvl(notification_id,0), nvl(process_activity,0) 21: from wf_item_activity_statuses 22: where item_type = itype
23: and item_key = ikey
24: and activity_status='NOTIFIED'
25: order by begin_date desc, execution_time desc;