DBA Data[Home] [Help]

APPS.GME_ERES_PKG dependencies on WF_CORE

Line 259: AND b.system_guid = HEXTORAW(wf_core.TRANSLATE('WF_SYSTEM_GUID'))

255: -- Namit S. Bug#4917171 Added the following 2 clauses.
256: -- Table wf_event_subscriptions has index on EVENT_FILTER_GUID, source_type, system_guid.
257: -- Adding the 2 clauses removes Full Table Scan of wf_event_subscriptions.
258: AND b.source_type = 'LOCAL'
259: AND b.system_guid = HEXTORAW(wf_core.TRANSLATE('WF_SYSTEM_GUID'))
260: AND b.RULE_FUNCTION ='EDR_PSIG_RULE.PSIG_RULE'
261: AND a.name = p_event_name
262: AND b.status = 'ENABLED'
263: ORDER BY b.STATUS DESC;

Line 271: AND b.system_guid = HEXTORAW(wf_core.TRANSLATE('WF_SYSTEM_GUID'))

267: wf_event_subscriptions b
268: WHERE a.guid=b.EVENT_FILTER_GUID
269: -- Namit S. Bug#4917171 Added the following 2 clauses.
270: AND b.source_type = 'LOCAL'
271: AND b.system_guid = HEXTORAW(wf_core.TRANSLATE('WF_SYSTEM_GUID'))
272: AND b.RULE_FUNCTION ='EDR_PSIG_RULE.PSIG_RULE'
273: AND b.status = 'ENABLED'
274: AND a.name = p_event_name;
275: IF l_cnt > 1 THEN