DBA Data[Home] [Help]

APPS.EDR_ERES_EVENT_PUB dependencies on WF_EVENT_SUBSCRIPTIONS

Line 308: from wf_events a, wf_event_subscriptions b

304:
305: -- Bug Start: 5087502
306: -- Verify if an active ERES subscription is available for current event.
307: select count(*) INTO l_no_enabled_eres_sub
308: from wf_events a, wf_event_subscriptions b
309: where a.GUID = b.EVENT_FILTER_GUID
310: and a.name = p_event_name
311: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
312: and b.STATUS = 'ENABLED'