APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_GROUPS_VL

Line 78: l_group_id jtf_rs_groups_vl.group_id%TYPE;

74: )
75: RETURN number IS
76:
77: l_total_num_of_agents NUMBER:=0;
78: l_group_id jtf_rs_groups_vl.group_id%TYPE;
79: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
80:
81:
82:

Line 88: FROM jtf_rs_groups_vl a,

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
90: WHERE b.usage='CALL'
91: AND b.group_ID=a.group_ID
92: AND a.start_date_active<=sysdate

Line 129: l_group_id jtf_rs_groups_vl.group_id%TYPE;

125: RETURN number IS
126:
127: l_total_num_of_agents NUMBER:=0;
128: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
129: l_group_id jtf_rs_groups_vl.group_id%TYPE;
130:
131:
132: CURSOR csr_agents IS
133: SELECT resource_id

Line 137: FROM jtf_rs_groups_vl a,

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
139: WHERE b.usage='CALL'
140: AND b.group_ID=a.group_ID
141: AND a.start_date_active<=sysdate

Line 312: from jtf_rs_groups_vl a,

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
314: where upper(a.group_name) = upper(p_group_name)
315: and b.usage='CALL'
316: and b.group_ID=a.group_ID

Line 333: -- FROM jtf_rs_groups_vl a,

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
335: -- WHERE b.usage='CALL'
336: -- AND b.group_ID=a.group_ID
337: -- AND a.start_date_active<=sysdate

Line 411: -- FROM jtf_rs_groups_vl a,

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
413: -- WHERE b.usage='CALL'
414: -- AND b.group_ID=a.group_ID
415: -- AND a.start_date_active<=sysdate