DBA Data[Home] [Help]

APPS.IEM_SPV_MONITORING_PVT dependencies on IEU_SH_SESSIONS

Line 368: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id_tbl(l_index);

364:
365: select count(*) into l_agent_acct_count from iem_agents where resource_id=l_resource_id_tbl(l_index);
366:
367: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
368: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id_tbl(l_index);
369:
370: x_agent_activity_tbl(l_monitor_index).resource_id:=l_resource_id_tbl(l_index);
371: x_agent_activity_tbl(l_monitor_index).resource_account_name:=l_resource_name_tbl(l_index);
372: x_agent_activity_tbl(l_monitor_index).email_account_id:=-1; -- All Accounts