APPS.EDR_STANDARD dependencies on WF_EVENT_SUBSCRIPTIONS

Line 80: wf_events a, wf_event_subscriptions b

76: l_eRecord_required varchar2(1);
77: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
78: select b.guid,A.status,b.status
79: from
80: wf_events a, wf_event_subscriptions b
81: where a.GUID = b.EVENT_FILTER_GUID
82: and a.name = p_event
83: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
84: and b.STATUS = 'ENABLED'

Line 112: wf_events a, wf_event_subscriptions b

108: -- Verify is more than one active ERES subscriptions are present
109: --
110: select count(*) INTO l_no_enabled_eres_sub
111: from
112: wf_events a, wf_event_subscriptions b
113: where a.GUID = b.EVENT_FILTER_GUID
114: and a.name = p_event
115: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
116: and b.STATUS = 'ENABLED'

Line 321: wf_events a, wf_event_subscriptions b

317:
318: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
319: select b.guid,A.status,b.status
320: from
321: wf_events a, wf_event_subscriptions b
322: where a.GUID = b.EVENT_FILTER_GUID
323: and a.name = p_event
324: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
325: and b.STATUS = 'ENABLED'

Line 354: wf_events a, wf_event_subscriptions b

350: -- Verify is more than one active ERES subscriptions are present
351: --
352: select count(*) into l_no_enabled_eres_sub
353: from
354: wf_events a, wf_event_subscriptions b
355: where a.GUID = b.EVENT_FILTER_GUID
356: and a.name = p_event
357: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
358: and b.STATUS = 'ENABLED'