APPS.IEM_QUEUE_MANAGEMENT_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 917: jtf_rs_group_members c, iem_agents d, jtf_rs_group_usages gu

913: trunc(sysdate) between trunc(nvl(e.start_date_active, sysdate))
914: and trunc(nvl(e.end_date_active, sysdate))
915: and f.group_id=e.group_id and f.resource_id=0 and f.email_account_id=:email_account_id and f.group_id in (
916: select unique c.group_id from
917: jtf_rs_group_members c, iem_agents d, jtf_rs_group_usages gu
918: where
919: c.delete_flag = ''N'' and c.resource_id = d.resource_id and d.email_account_id =:l_email_account_id
920: and c.group_id = gu.group_id and gu.usage = ''CALL''
921: ) group by f.group_id, e.group_name

Line 924: jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e,

920: and c.group_id = gu.group_id and gu.usage = ''CALL''
921: ) group by f.group_id, e.group_name
922: union all
923: select unique e.group_id, group_name, 0 from
924: jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e,
925: jtf_rs_group_usages gu where
926: c.group_id = e.group_id
927: and c.delete_flag = ''N'' and c.resource_id = d.resource_id and d.email_account_id =:l_email_account_id
928: and trunc(sysdate) between trunc(nvl(e.start_date_active, sysdate))

Line 962: --select count(*) into l_agent_count from jtf_rs_roles_tl a, jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d

958: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
959: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_email_count);
960:
961: -- Start changes for bug no. 7418671
962: --select count(*) into l_agent_count from jtf_rs_roles_tl a, jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d
963: --where a.role_id in (28, 29, 30) and a.language = USERENV ('LANG') and a.role_id = b.role_id and b.delete_flag = 'N'
964: --and b.role_resource_id = c.resource_id and c.delete_flag = 'N' and c.resource_id = d.resource_id
965: --and d.email_account_id = l_email_account_id and c.group_id = l_group_id;
966: SELECT count(*) into l_agent_count

Line 967: FROM jtf_rs_group_members c, iem_agents d

963: --where a.role_id in (28, 29, 30) and a.language = USERENV ('LANG') and a.role_id = b.role_id and b.delete_flag = 'N'
964: --and b.role_resource_id = c.resource_id and c.delete_flag = 'N' and c.resource_id = d.resource_id
965: --and d.email_account_id = l_email_account_id and c.group_id = l_group_id;
966: SELECT count(*) into l_agent_count
967: FROM jtf_rs_group_members c, iem_agents d
968: WHERE c.resource_id IN
969: (select b.role_resource_id from jtf_rs_role_relations b
970: where b.role_resource_id=c.resource_id and b.role_id IN (28,29,30)
971: AND b.delete_flag='N'

Line 1004: -- jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu

1000: end if;
1001:
1002: -- Start changes for bug no. 7418671
1003: --l_string := 'select e.group_id, e.group_name, count(*) agent_count from
1004: -- jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu
1005: -- where b.delete_flag = ''N'' and b.role_id in (28, 29, 30)
1006: -- and b.role_resource_id = c.resource_id and c.group_id = e.group_id
1007: -- and c.resource_id=res.resource_id
1008: -- and c.group_id = gu.group_id

Line 1020: FROM jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu

1016: -- and c.delete_flag = ''N''
1017: -- and c.resource_id = d.resource_id and d.email_account_id = :l_email_account_id
1018: -- group by e.group_id, e.group_name ';
1019: l_string := 'SELECT e.group_id, e.group_name, COUNT(*) agent_count
1020: FROM jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu
1021: WHERE c.group_id = e.group_id AND c.resource_id = res.resource_id
1022: AND c.group_id = gu.group_id
1023: AND c.resource_id in
1024: (select b.role_resource_id from jtf_rs_role_relations b