272: '',
273: '',
274: subscription_on_error_type,
275: ''
276: from wf_active_subscriptions_v
277: where event_name in(cp_event_name, g_event_any)
278: and subscription_source_type = cp_source_type
279: and ((subscription_source_agent_guid is NOT NULL AND
280: subscription_source_agent_guid = nvl(cp_source_agent_guid, subscription_source_agent_guid))