APPS.BIX_REAL_TIME_BINS_PKG dependencies on CCT_AGENT_RT_STATS

Line 122: from CCT_AGENT_RT_STATS C1

118: and I1.begin_date_time between l_date_low and l_date_high;
119:
120: /* get talking agents */
121: Select count(distinct C1.agent_id) into talk
122: from CCT_AGENT_RT_STATS C1
123: where C1.has_call = 'T'
124: and C1.last_update_date between l_date_low and l_date_high;
125:
126: /* get wrapping agents */

Line 130: CCT_AGENT_RT_STATS C1

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'
134: and I2.activity_type_code = 'MEDIA'