DBA Data[Home] [Help]

APPS.AS_BUSINESS_EVENT_PVT dependencies on WF_EVENT_SUBSCRIPTIONS

Line 93: wf_event_subscriptions sub

89: IS
90: CURSOR cu0 IS
91: SELECT 'Y'
92: FROM wf_events eve,
93: wf_event_subscriptions sub
94: WHERE eve.name = p_event_name
95: AND eve.status = 'ENABLED'
96: AND eve.guid = sub.event_filter_guid
97: AND UPPER(sub.rule_function) = 'AS_BUSINESS_EVENT_PVT.EVENT_DATA_DELETE'

Line 102: FROM wf_event_subscriptions sub1

98: AND sub.status = 'ENABLED'
99: AND sub.source_type = 'LOCAL'
100: AND EXISTS (
101: SELECT 'X'
102: FROM wf_event_subscriptions sub1
103: WHERE sub1.event_filter_guid = eve.guid
104: AND UPPER(sub1.rule_function) <> 'AS_BUSINESS_EVENT_PVT.EVENT_DATA_DELETE'
105: AND sub1.status = 'ENABLED'
106: AND sub1.source_type = 'LOCAL')