APPS.GMO_MBR_UTIL dependencies on WF_EVENT_SUBSCRIPTIONS

Line 39: wf_event_subscriptions b

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
43: ORDER BY b.STATUS DESC;

Line 47: wf_event_subscriptions b

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'
51: and a.name = p_event_name;