APPS.BIX_DM_SESSIONINFO_SUMMARY_PKG dependencies on IEU_SH_SESSIONS

Line 445: FROM ieu_sh_sessions iss

441: SELECT iss.session_id session_id,
442: iss.resource_id resource_id,
443: iss.begin_date_time begin_date_time,
444: iss.end_date_time end_date_time
445: FROM ieu_sh_sessions iss
446: WHERE iss.application_id = 696
447: AND iss.begin_date_time <= g_rounded_collect_end_date
448: AND (iss.end_date_time >= g_rounded_collect_start_date
449: OR iss.end_date_time is NULL ) ;

Line 570: FROM ieu_sh_sessions iss,

566: CURSOR get_avail_time IS
567: SELECT iss.resource_id resource_id,
568: isa.begin_date_time begin_date_time,
569: isa.deliver_date_time end_date_time
570: FROM ieu_sh_sessions iss,
571: ieu_sh_activities isa
572: WHERE isa.begin_date_time <= g_rounded_collect_end_date
573: AND (isa.deliver_date_time >= g_rounded_collect_start_date
574: OR (isa.deliver_date_time is NULL AND isa.end_date_time IS NULL)

Line 583: FROM ieu_sh_sessions iss,

579: UNION ALL
580: SELECT iss.resource_id resource_id,
581: isa.begin_date_time begin_date_time,
582: isa.end_date_time end_date_time
583: FROM ieu_sh_sessions iss,
584: ieu_sh_activities isa
585: WHERE isa.begin_date_time <= g_rounded_collect_end_date
586: AND isa.end_date_time >= g_rounded_collect_start_date
587: AND isa.deliver_date_time IS NULL

Line 855: /* Procedure collects Agent login time from IEU_SH_SESSIONS table */

851:
852: /* Delete data between these dates and re-compute */
853: delete_in_chunks( 'BIX_DM_AGENT_SESSION_SUM', 1, g_delete_count);
854:
855: /* Procedure collects Agent login time from IEU_SH_SESSIONS table */
856: collect_agent_login_time;
857:
858: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
859: ,IEU_SH_ACTIVITIES tables */

Line 858: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS

854:
855: /* Procedure collects Agent login time from IEU_SH_SESSIONS table */
856: collect_agent_login_time;
857:
858: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
859: ,IEU_SH_ACTIVITIES tables */
860: collect_agent_avail_time;
861:
862: /* Insert the status into BIX_DM_COLLECT_LOG table */