APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 85: FROM jtf_rs_group_members

81:
82:
83: CURSOR csr_agents IS
84: SELECT resource_id
85: FROM jtf_rs_group_members
86: WHERE delete_flag='N'
87: AND group_id = ( SELECT distinct a.group_id
88: FROM jtf_rs_groups_vl a,
89: jtf_rs_group_usages_vl b

Line 134: FROM jtf_rs_group_members

130:
131:
132: CURSOR csr_agents IS
133: SELECT resource_id
134: FROM jtf_rs_group_members
135: WHERE delete_flag='N'
136: AND group_id= ( SELECT a.group_id
137: FROM jtf_rs_groups_vl a,
138: jtf_rs_group_usages_vl b

Line 309: from jtf_rs_group_members

305: and (roles.role_type_code = 'CALLCENTER'
306: or roles.role_type_code='ICENTER')
307: MINUS
308: select resource_id
309: from jtf_rs_group_members
310: where delete_flag='N'
311: and group_id = ( select a.group_id
312: from jtf_rs_groups_vl a,
313: jtf_rs_group_usages b

Line 330: -- FROM jtf_rs_group_members

326: -- and (roles.role_type_code = 'CALLCENTER'
327: -- or roles.role_type_code='ICENTER')
328: -- MINUS
329: -- SELECT resource_id
330: -- FROM jtf_rs_group_members
331: -- WHERE delete_flag='N'
332: -- AND group_id= ( SELECT distinct a.group_id
333: -- FROM jtf_rs_groups_vl a,
334: -- jtf_rs_group_usages_vl b

Line 386: from jtf_rs_group_members

382: and (roles.role_type_code = 'CALLCENTER'
383: or roles.role_type_code='ICENTER')
384: MINUS
385: select resource_id
386: from jtf_rs_group_members
387: where delete_flag='N'
388: and group_id = ( select a.group_id
389: from jtf_rs_groups_b a,
390: jtf_rs_group_usages b

Line 408: -- FROM jtf_rs_group_members

404: -- and (roles.role_type_code = 'CALLCENTER'
405: -- or roles.role_type_code='ICENTER')
406: -- MINUS
407: -- SELECT resource_id
408: -- FROM jtf_rs_group_members
409: -- WHERE delete_flag='N'
410: -- AND group_id = ( SELECT a.group_id
411: -- FROM jtf_rs_groups_vl a,
412: -- jtf_rs_group_usages_vl b