APPS.BIX_REAL_TIME_BINS_PKG dependencies on IEU_SH_ACTIVITIES

Line 109: IEU_SH_ACTIVITIES I2

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'
113: and I1.end_date_time is NULL

Line 129: IEU_SH_ACTIVITIES I2,

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
133: and I2.active_flag ='T'