APPS.BIX_REAL_TIME_BINS_PKG dependencies on IEU_SH_SESSIONS

Line 108: from IEU_SH_SESSIONS I1,

104: and bin_code = 'BIX_AGENT_STATUS';
105:
106: /* get available agents */
107: select count(distinct I1.resource_id) into available
108: from IEU_SH_SESSIONS I1,
109: IEU_SH_ACTIVITIES I2
110: where I1.session_id = I2.session_id
111: and I1.application_id = 696
112: and I1.active_flag ='T'

Line 128: from IEU_SH_SESSIONS I1,

124: and C1.last_update_date between l_date_low and l_date_high;
125:
126: /* get wrapping agents */
127: Select count(distinct I1.resource_id) into wrap
128: from IEU_SH_SESSIONS I1,
129: IEU_SH_ACTIVITIES I2,
130: CCT_AGENT_RT_STATS C1
131: where I1.session_id = I2.session_id
132: and I1.application_id = 696

Line 143: from IEU_SH_SESSIONS I1

139: and I1.begin_date_time between l_date_low and l_date_high;
140:
141: /* get agents who are logged into UWQ */
142: Select count(distinct I1.resource_id) into loggedin
143: from IEU_SH_SESSIONS I1
144: where I1.active_flag = 'T'
145: and I1.application_id = 696
146: and I1.end_date_time is NULL
147: and I1.begin_date_time between l_date_low and l_date_high;

Line 151: from IEU_SH_SESSIONS I1

147: and I1.begin_date_time between l_date_low and l_date_high;
148:
149: /* get agents who are logged into UWQ */
150: Select count(distinct I1.resource_id) into out
151: from IEU_SH_SESSIONS I1
152: where I1.active_flag <> 'T'
153: and I1.application_id = 696
154: and I1.end_date_time is not NULL
155: and I1.begin_date_time between l_date_low and l_date_high

Line 157: select distinct(resource_id) from IEU_SH_SESSIONS

153: and I1.application_id = 696
154: and I1.end_date_time is not NULL
155: and I1.begin_date_time between l_date_low and l_date_high
156: and I1.resource_id not in(
157: select distinct(resource_id) from IEU_SH_SESSIONS
158: where active_flag = 'T'
159: and application_id = 696
160: and end_date_time is null
161: and begin_date_time between l_date_low and l_date_high