APPS.WF_SETUP dependencies on WF_SYSTEMS

Line 29: from WF_SYSTEMS S, WF_RESOURCES R

25: is
26: lsys varchar2(30);
27: begin
28: select S.NAME into lsys
29: from WF_SYSTEMS S, WF_RESOURCES R
30: where R.NAME = 'WF_SYSTEM_GUID'
31: and R.LANGUAGE = userenv('LANG')
32: and S.GUID = hextoraw(R.TEXT);
33:

Line 409: and TA.SYSTEM_GUID in (select GUID from WF_SYSTEMS)

405: and TA.PROTOCOL = 'SQLNET'
406: and TA.DIRECTION = 'IN'
407: and TA.ADDRESS IS NOT NULL
408: and TA.NAME <> 'WF_ERROR'
409: and TA.SYSTEM_GUID in (select GUID from WF_SYSTEMS)
410: union
411: -- propgation to a local queue
412: select A.GUID OGUID,
413: A.NAME,