APPS.GME_ERES_PKG dependencies on WF_EVENTS_VL

Line 252: FROM wf_events_vl a,

248: l_CNT NUMBER;
249: CURSOR GET_MAP_CODE IS
250: SELECT DISTINCT b.STATUS,
251: EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',b.GUID) map_code
252: FROM wf_events_vl a,
253: wf_event_subscriptions b
254: WHERE a.guid=b.EVENT_FILTER_GUID
255: -- Namit S. Bug#4917171 Added the following 2 clauses.
256: -- Table wf_event_subscriptions has index on EVENT_FILTER_GUID, source_type, system_guid.

Line 266: FROM wf_events_vl a,

262: AND b.status = 'ENABLED'
263: ORDER BY b.STATUS DESC;
264: BEGIN
265: SELECT COUNT(*) INTO l_cnt
266: FROM wf_events_vl a,
267: wf_event_subscriptions b
268: WHERE a.guid=b.EVENT_FILTER_GUID
269: -- Namit S. Bug#4917171 Added the following 2 clauses.
270: AND b.source_type = 'LOCAL'