APPS.BIX_DM_SESSBYCAMP_PKG dependencies on IEU_SH_SESSIONS

Line 298: FROM ieu_sh_sessions sess,

294: campsch.schedule_id campaign_schedule_id,
295: res.server_group_id server_group_id,
296: act.begin_date_time begin_date_time,
297: act.end_date_time end_date_time
298: FROM ieu_sh_sessions sess,
299: ieu_sh_activities act,
300: --ieu_uwq_media_types_tl med,
301: jtf_rs_resource_extns res,
302: ams_campaign_schedules_b campsch

Line 428: FROM ieu_sh_sessions sess,

424: campsch.campaign_id campaign_id,
425: campsch.schedule_id campaign_schedule_id,
426: act1.begin_date_time begin_date_time,
427: act1.deliver_date_time end_date_time
428: FROM ieu_sh_sessions sess,
429: ieu_sh_activities act1,
430: ieu_sh_activities act2,
431: --ieu_uwq_media_types_tl med,
432: jtf_rs_resource_extns res,

Line 457: FROM ieu_sh_sessions sess,

453: campsch.campaign_id campaign_id,
454: campsch.schedule_id campaign_schedule_id,
455: act1.begin_date_time begin_date_time,
456: act1.end_date_time end_date_time
457: FROM ieu_sh_sessions sess,
458: ieu_sh_activities act1,
459: ieu_sh_activities act2,
460: jtf_rs_resource_extns res,
461: ams_campaign_schedules_b campsch

Line 757: /* Procedure collects Agent work time from IEU_SH_SESSIONS table */

753:
754: /* Delete data between these dates and re-compute */
755: delete_in_chunks( 'BIX_DM_AGENT_SESSBYCAMP_SUM', 1, g_delete_count);
756:
757: /* Procedure collects Agent work time from IEU_SH_SESSIONS table */
758: collect_agent_work_time;
759:
760: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
761: ,IEU_SH_ACTIVITIES tables */

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

756:
757: /* Procedure collects Agent work time from IEU_SH_SESSIONS table */
758: collect_agent_work_time;
759:
760: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
761: ,IEU_SH_ACTIVITIES tables */
762: collect_agent_avail_time;
763:
764: /* Insert the status into BIX_DM_COLLECT_LOG table */