APPS.BIX_DM_SESSIONINFO_SUMMARY_PKG dependencies on IEU_SH_ACTIVITIES

Line 264: FROM ieu_sh_activities

260: l_count NUMBER := 0;
261:
262: CURSOR get_media_cycle_time IS
263: SELECT begin_date_time,end_date_time
264: FROM ieu_sh_activities
265: WHERE session_id = l_session_id
266: AND activity_type_code = 'MEDIA_CYCLE'
267: ORDER BY begin_date_time;
268:

Line 571: ieu_sh_activities isa

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)
575: )

Line 584: ieu_sh_activities isa

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
588: AND iss.application_id = 696

Line 859: ,IEU_SH_ACTIVITIES tables */

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 */
863: g_run_end_date := sysdate;