APPS.CSM_HA_EVENT_PKG dependencies on WF_EVENT_SUBSCRIPTIONS

Line 623: UPDATE wf_event_subscriptions SET STATUS='DISABLED'

619: IF rec.WF_EVENT_NAME IS NOT NULL THEN
620: IF rec.WF_EVENT_SUBSCRIPTION_GUID IS NULL THEN
621: UPDATE wf_events SET STATUS='DISABLED' WHERE lower(name)=lower(rec.WF_EVENT_NAME);
622: ELSE
623: UPDATE wf_event_subscriptions SET STATUS='DISABLED'
624: WHERE GUID=rec.WF_EVENT_SUBSCRIPTION_GUID
625: AND EVENT_FILTER_GUID = (select guid from wf_events where lower(name)=lower(rec.WF_EVENT_NAME));
626: END IF;
627: END IF;