APPS.GMO_MBR_UTIL dependencies on WF_EVENTS_VL

Line 38: from wf_events_vl a,

34: l_CNT NUMBER;
35: CURSOR GET_MAP_CODE IS
36: SELECT distinct b.STATUS,
37: EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',b.GUID) map_code
38: from wf_events_vl a,
39: wf_event_subscriptions b
40: WHERE a.guid=b.EVENT_FILTER_GUID
41: and b.RULE_FUNCTION ='EDR_PSIG_RULE.PSIG_RULE'
42: and a.name = p_event_name

Line 46: from wf_events_vl a,

42: and a.name = p_event_name
43: ORDER BY b.STATUS DESC;
44: BEGIN
45: select count(*) INTO l_cnt
46: from wf_events_vl a,
47: wf_event_subscriptions b
48: WHERE a.guid=b.EVENT_FILTER_GUID
49: and b.RULE_FUNCTION ='EDR_PSIG_RULE.PSIG_RULE'
50: and b.status = 'ENABLED'