APPS.IEM_CLIENT_PUB dependencies on IEU_SH_SESSIONS

Line 1318: SELECT session_id from IEU_SH_SESSIONS

1314: l_rt_media_item_id_ib number;
1315: l_type VARCHAR2(2);
1316:
1317: CURSOR sel_csr IS
1318: SELECT session_id from IEU_SH_SESSIONS
1319: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
1320: FROM IEU_SH_SESSIONS
1321: WHERE RESOURCE_ID = l_resource_id
1322: AND ACTIVE_FLAG = 'T'

Line 1320: FROM IEU_SH_SESSIONS

1316:
1317: CURSOR sel_csr IS
1318: SELECT session_id from IEU_SH_SESSIONS
1319: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
1320: FROM IEU_SH_SESSIONS
1321: WHERE RESOURCE_ID = l_resource_id
1322: AND ACTIVE_FLAG = 'T'
1323: AND APPLICATION_ID = 680);
1324: BEGIN

Line 2033: SELECT session_id from IEU_SH_SESSIONS

2029: --Employee Search. shramana.
2030: l_acct_type varchar2(1);
2031:
2032: CURSOR sel_csr IS
2033: SELECT session_id from IEU_SH_SESSIONS
2034: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
2035: FROM IEU_SH_SESSIONS
2036: WHERE RESOURCE_ID = l_resource_id
2037: AND ACTIVE_FLAG = 'T'

Line 2035: FROM IEU_SH_SESSIONS

2031:
2032: CURSOR sel_csr IS
2033: SELECT session_id from IEU_SH_SESSIONS
2034: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
2035: FROM IEU_SH_SESSIONS
2036: WHERE RESOURCE_ID = l_resource_id
2037: AND ACTIVE_FLAG = 'T'
2038: AND APPLICATION_ID = 680);
2039: