APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_RS_GROUPS_DENORM

Line 3325: jtf_rs_groups_denorm group_denorm

3321: SUM(agent_sum.OUT_PREVIEW_TIME) OUT_PREVIEW_TIME,
3322: SUM(agent_sum.OUT_CONTACT_HANDLE_TIME) OUT_CONTACT_HANDLE_TIME
3323: FROM bix_dm_agent_sum agent_sum,
3324: jtf_rs_group_members groups,
3325: jtf_rs_groups_denorm group_denorm
3326: WHERE agent_sum.period_start_date_time BETWEEN g_min_call_begin_date AND g_max_call_begin_date
3327: AND agent_sum.resource_id = groups.resource_id
3328: AND groups.group_id = group_denorm.group_id
3329: --

Line 3344: from jtf_rs_groups_denorm den1

3340: (select max(mem1.group_member_id)
3341: from jtf_rs_group_members mem1
3342: where mem1.group_id in
3343: (select den1.group_id
3344: from jtf_rs_groups_denorm den1
3345: where den1.parent_group_id = group_denorm.parent_group_id
3346: AND agent_sum.period_start_date_time BETWEEN
3347: NVL(den1.start_date_active,agent_sum.period_start_date_time)
3348: AND NVL(den1.end_date_active,SYSDATE)

Line 4119: jtf_rs_groups_denorm group_denorm

4115: call_stage.positive_response_flag POSITIVE_RESPONSE_FLAG,
4116: sum(call_stage.number_of_calls) NUMBER_OF_CALLS
4117: FROM bix_dm_agent_outcome_sum call_stage,
4118: jtf_rs_group_members groups,
4119: jtf_rs_groups_denorm group_denorm
4120: WHERE call_stage.resource_id = groups.resource_id
4121: AND call_stage.period_start_date_time BETWEEN g_min_call_begin_date AND g_max_call_begin_date
4122: AND groups.group_id = group_denorm.group_id
4123: AND call_stage.resource_id IS NOT NULL

Line 4139: from jtf_rs_groups_denorm den1

4135: (select max(mem1.group_member_id)
4136: from jtf_rs_group_members mem1
4137: where mem1.group_id in
4138: (select den1.group_id
4139: from jtf_rs_groups_denorm den1
4140: where den1.parent_group_id = group_denorm.parent_group_id
4141: AND call_stage.period_start_date_time BETWEEN
4142: NVL(den1.start_date_active,call_stage.period_start_date_time)
4143: AND NVL(den1.end_date_active,SYSDATE)