APPS.WF_DIAGNOSTICS dependencies on WF_EVENTS

Line 3480: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas

3476: DECODE(sub.guid, NULL, 'Subscription Not Defined',
3477: DECODE(sub.out_agent_guid, NULL, 'Not Defined',
3478: oa.name || '@' || oas.name)) OUT_AGENT,
3479: sub.status STATUS
3480: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas
3481: WHERE e.NAME IN ('oracle.apps.wf.notification.send.group',
3482: 'oracle.apps.fnd.cp.gsc.bes.control.group',
3483: 'oracle.apps.wf.notification.summary.send')
3484: AND e.guid = sub.event_filter_guid(+)

Line 4150: from wf_events

4146: customization_level cust_level,
4147: licensed_flag lic_flag
4148: into l_type, l_status, l_own_name, l_own_tag,
4149: l_gen_func, l_jgen_func, l_cust_level, l_lic_flag
4150: from wf_events
4151: where name = p_event_name;
4152:
4153: l_cells(9) := l_type;
4154: l_cells(10) := l_status;

Line 4388: from wf_events

4384:
4385: begin
4386: select null
4387: into l_dummy
4388: from wf_events
4389: where name = p_event_name;
4390: exception
4391: when NO_DATA_FOUND then
4392: l_cells(1) := 'WH: Event '||p_event_name||' has been purged and is not available in the Database.';