APPS.EDR_ISIGN_CHECKLIST_PVT dependencies on WF_EVENT_SUBSCRIPTIONS

Line 53: wf_events a, wf_event_subscriptions b

49: l_temp_template_ver varchar2(200);
50: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
51: select b.guid,A.status,b.status
52: from
53: wf_events a, wf_event_subscriptions b
54: where a.GUID = b.EVENT_FILTER_GUID
55: and a.name = p_event_name
56: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
57: and b.STATUS = 'ENABLED'

Line 78: wf_events a, wf_event_subscriptions b

74: -- Verify is more than one active ERES subscriptions are present
75: --
76: select count(*) INTO l_no_enabled_eres_sub
77: from
78: wf_events a, wf_event_subscriptions b
79: where a.GUID = b.EVENT_FILTER_GUID
80: and a.name = p_event_name
81: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
82: and b.STATUS = 'ENABLED'