APPS.EDR_ERES_EVENT_PVT dependencies on WF_EVENTS_VL

Line 22: from wf_events_vl a, wf_event_subscriptions b

18: l_no_of_eres_sub NUMBER;
19:
20: cursor enabled_subscription_csr is
21: select b.guid
22: from wf_events_vl a, wf_event_subscriptions b
23: where a.guid=b.EVENT_FILTER_GUID
24: and a.name = p_event_name
25: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
26: and b.status = 'ENABLED'

Line 34: from wf_events_vl a, wf_event_subscriptions b

30: --Bug No 4912782- End
31:
32: cursor single_subscription_csr is
33: select b.guid
34: from wf_events_vl a, wf_event_subscriptions b
35: where a.guid=b.EVENT_FILTER_GUID
36: and a.name = p_event_name
37: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
38: --Bug No 4912782- Start

Line 672: from wf_events_vl a,

668: --If there are > 1 subscriptions, and one is enabled query returns >1
669: -- rows. Hence adding two more conditions in where clause
670:
671: SELECT EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',b.guid) into l_ame_txn_type
672: from wf_events_vl a,
673: wf_event_subscriptions b
674: WHERE a.guid=b.EVENT_FILTER_GUID
675: and a.name = p_event_name
676: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'