APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 3324: jtf_rs_group_members groups,

3320: SUM(agent_sum.OUT_OTHER_OUTCOME_COUNT) OUT_OTHER_OUTCOME_COUNT,
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

Line 3341: from jtf_rs_group_members mem1

3337: NVL(group_denorm.start_date_active,agent_sum.period_start_date_time)
3338: AND NVL(group_denorm.end_date_active,SYSDATE)
3339: AND groups.group_member_id =
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

Line 4118: jtf_rs_group_members groups,

4114: call_stage.contact_flag CONTACT_FLAG,
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

Line 4136: from jtf_rs_group_members mem1

4132: NVL(group_denorm.start_date_active,call_stage.period_start_date_time)
4133: AND NVL(group_denorm.end_date_active,SYSDATE)
4134: AND groups.group_member_id =
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