DBA Data[Home] [Help]

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;