APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_DYNAMIC_GROUPS_B

Line 175: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;

171: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
172: )
173: RETURN number IS
174: l_total_num_of_agents NUMBER:=0;
175: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;
176: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
177: l_select_csr INTEGER;
178: l_sort_num NUMBER := 0;
179: l_dummy INTEGER;

Line 232: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;

228: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
229: )
230: RETURN number IS
231: l_total_num_of_agents NUMBER:=0;
232: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;
233: l_dummy INTEGER;
234: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
235: l_sort_num NUMBER := 0;
236:

Line 241: FROM JTF_RS_DYNAMIC_GROUPS_B a

237: l_select_csr INTEGER;
238:
239: CURSOR csr_text IS
240: SELECT a.sql_text
241: FROM JTF_RS_DYNAMIC_GROUPS_B a
242: WHERE upper(a.usage)='CALL'
243: AND a.start_date_active<=sysdate
244: AND nvl(a.end_date_active,sysdate)>=sysdate
245: AND a.group_number = p_group_number

Line 450: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;

446: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
447: l_default_select VARCHAR2(4000);
448: l_apos VARCHAR2(4) := '''';
449: l_query VARCHAR2(5000);
450: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;
451: l_select_csr INTEGER;
452: l_dummy INTEGER;
453: l_sort_num NUMBER := 0;
454:

Line 525: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;

521: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
522: l_default_select VARCHAR2(4000);
523: l_apos VARCHAR2(4) := '''';
524: l_query VARCHAR2(5000);
525: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;
526: l_select_csr INTEGER;
527: l_dummy INTEGER;
528: l_sort_num NUMBER := 0;
529: