DBA Data[Home] [Help]

APPS.WF_ALERT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 28: from wf_item_activity_statuses

24: dummy varchar2(30);
25:
26: cursor error_cursor (lastrun in date) is
27: select 'errors exist'
28: from wf_item_activity_statuses
29: where activity_status = 'ERROR'
30: and begin_date >= nvl(lastrun,begin_date);
31:
32: begin

Line 108: from wf_item_activity_statuses ias,

104: ias.activity_result_code Result,
105: -- ias.error_name ERROR_NAME,
106: ias.error_message ERROR_MESSAGE,
107: ias.error_stack ERROR_STACK
108: from wf_item_activity_statuses ias,
109: wf_process_activities pa,
110: wf_activities ac,
111: wf_activities ap,
112: wf_items i