DBA Data[Home] [Help]

APPS.IEM_EMAILACCOUNT_PUB dependencies on IEU_SH_SESSIONS

Line 520: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;

516: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
517: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
518:
519: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
520: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
521:
522: l_temp_tbl(l_counter).resource_id := l_resource_id;
523: l_temp_tbl(l_counter).resource_name := l_resource_name;
524: l_temp_tbl(l_counter).user_name := l_user_name;