DBA Data[Home] [Help]

APPS.IEM_EMAILACCOUNT_PUB dependencies on IEU_SH_SESSIONS

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

398: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
399: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
400:
401: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
402: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
403:
404: l_temp_tbl(l_counter).resource_id := l_resource_id;
405: l_temp_tbl(l_counter).resource_name := l_resource_name;
406: l_temp_tbl(l_counter).user_name := l_user_name;