APPS.WF_EVENT_PING_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

SELECT
	wfa.name AGENT,
	wfs.name SYSTEM
FROM
	wf_systems wfs,
	wf_agents wfa
WHERE
	wfa.name <> 'WF_ERROR'
and	wfa.status = 'ENABLED'
and	wfa.direction = 'IN'
and	wfa.system_guid = wfs.guid
and     upper(wfa.queue_handler) = 'WF_EVENT_QH';

Line: 133

SELECT  wfa.name AGENT
FROM
        wf_systems wfs,
        wf_agents wfa,
        wf_resources res
WHERE
        res.name = 'WF_SYSTEM_GUID'
and     res.language = userenv('LANG')
and     wfa.system_guid = res.text
and     wfs.name = p_name
and     wfa.name <> 'WF_ERROR'
and     wfa.status = 'ENABLED'
and     wfa.direction = 'IN'
and     upper(wfa.queue_handler) = 'WF_EVENT_QH';