Check the active user in the Application

select fnd.user_name,
       icx.responsibility_application_id,
       icx.responsibility_id,
       frt.responsibility_name,
       icx.session_id,
       icx.first_connect,
       icx.last_connect,
       DECODE((icx.disabled_flag), 'N', 'ACTIVE', 'Y', 'INACTIVE') status
  from fnd_user fnd, icx_sessions icx, fnd_responsibility_tl frt
 where fnd.user_id = icx.user_id
   and icx.responsibility_id = frt.responsibility_id
   and icx.disabled_flag <> 'Y'
   and trunc(icx.last_connect) = trunc(sysdate)
 order by icx.last_connect;