eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WORKFLOW_SERVICE dependencies on ICX_SESSIONS

Line 1992: from icx_sessions s

1988: and wiav.item_type = wias.item_type
1989: and wiav.name = 'SESSION_ID'
1990: and not exists
1991: (select 1
1992: from icx_sessions s
1993: where s.session_id = wiav.number_value
1994: and s.disabled_flag = 'N');
1995: */
1996:

Line 2105: from wf_items wi , wf_item_attribute_values av, icx_sessions s

2101: -- 4287117
2102: --5076290
2103: CURSOR defunct_wf_ids (c_transaction_age in number) IS
2104: select wi.item_key
2105: from wf_items wi , wf_item_attribute_values av, icx_sessions s
2106: where wi.item_type= itemtype
2107: and trunc(wi.begin_date) <= trunc(sysdate) --fix for bug 6642996
2108: and wi.end_date is null
2109: and av.item_type = wi.item_type

Line 2154: and exists (select 'e' from wf_item_attribute_values av, icx_sessions s

2150: and wi.item_key = ts.item_key
2151: and ts.item_type is not null
2152: and ts.item_key is not null
2153: )
2154: and exists (select 'e' from wf_item_attribute_values av, icx_sessions s
2155: where av.item_type = wi.item_type
2156: and av.item_key = wi.item_key
2157: and av.name = 'SESSION_ID'
2158: and av.number_value = s.session_id(+)