APPS.WF_DIAGNOSTICS dependencies on WF_EVENTS

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

3125: DECODE(sub.guid, NULL, 'Subscription Not Defined',
3126: DECODE(sub.out_agent_guid, NULL, 'Not Defined',
3127: oa.name || '@' || oas.name)) OUT_AGENT,
3128: sub.status STATUS
3129: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas
3130: WHERE e.NAME IN ('oracle.apps.wf.notification.send.group',
3131: 'oracle.apps.fnd.cp.gsc.bes.control.group',
3132: 'oracle.apps.wf.notification.summary.send')
3133: AND e.guid = sub.event_filter_guid(+)

Line 3799: from wf_events

3795: customization_level cust_level,
3796: licensed_flag lic_flag
3797: into l_type, l_status, l_own_name, l_own_tag,
3798: l_gen_func, l_jgen_func, l_cust_level, l_lic_flag
3799: from wf_events
3800: where name = p_event_name;
3801:
3802: l_cells(9) := l_type;
3803: l_cells(10) := l_status;

Line 4037: from wf_events

4033:
4034: begin
4035: select null
4036: into l_dummy
4037: from wf_events
4038: where name = p_event_name;
4039: exception
4040: when NO_DATA_FOUND then
4041: l_cells(1) := 'WH: Event '||p_event_name||' has been purged and is not available in the Database.';