[Home] [Help]
616:
617: l_string := 'select resource_id, resource_name, last_login_time, real_last_login_time from (
618: select a.resource_id, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name,
619: to_char(max(c.begin_date_time), ''MM/DD/RRRR HH24:MI:SS'') as last_login_time, max(c.begin_date_time) as real_last_login_time
620: from iem_agents a, jtf_rs_resource_extns rs, ieu_sh_sessions c
621: where a.resource_id = rs.resource_id and a.resource_id=c.resource_id
622: and a.email_account_id =:email_account_id and c.application_id=680
623: and trunc(sysdate) between trunc(nvl(rs.start_date_active, sysdate))
624: and trunc(nvl(rs.end_date_active, sysdate))
661: and rel.role_resource_type = ''RS_INDIVIDUAL''
662: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
663: and trunc(nvl(rel.end_date_active, sysdate)) )
664: and a.resource_id not in
665: (select a.resource_id from iem_agents a, ieu_sh_sessions b where b.application_id=680 and
666: a.resource_id=b.resource_id and a.email_account_id =:email_account_id ) ) order by real_last_login_time ';
667:
668: l_string := l_string || l_string2 || l_sort_order;
669:
785: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
786: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
787:
788: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
789: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
790:
791: x_resource_count(l_index).resource_id :=l_resource_id;
792: x_resource_count(l_index).resource_name := l_resource_name;
793: x_resource_count(l_index).email_count := l_fetched_emails;