APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 28: v_agent_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%type;

24: )
25: RETURN NUMBER IS
26:
27: v_total_num_of_emps NUMBER:=0;
28: v_agent_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%type;
29:
30: --
31: -- get a list of employees that is responsible for a given comp name andy type
32: -- Changed 06FRB2002

Line 35: FROM jtf_rs_resource_extns res,

31: -- get a list of employees that is responsible for a given comp name andy type
32: -- Changed 06FRB2002
33: CURSOR c_employees IS
34: SELECT distinct res.resource_id
35: FROM jtf_rs_resource_extns res,
36: jtf_rs_role_relations res_roles,
37: jtf_rs_roles_b roles
38: where res.resource_id in
39: ((SELECT DISTINCT comp_ele.person_id

Line 296: from jtf_rs_resource_extns res

292:
293:
294: CURSOR csr_agents IS
295: select res.resource_id
296: from jtf_rs_resource_extns res
297: ,jtf_rs_role_relations res_roles
298: ,jtf_rs_roles_b roles
299: where res.resource_id = res_roles.role_resource_id
300: and res_roles.role_resource_type = 'RS_INDIVIDUAL'

Line 321: -- FROM jtf_rs_resource_extns res

317: and a.start_date_active<=sysdate
318: and nvl(a.end_date_active,sysdate)>=sysdate );
319: -- Changed 09/12/02 rajayara
320: --SELECT distinct res.resource_id
321: -- FROM jtf_rs_resource_extns res
322: -- ,jtf_rs_role_relations res_roles
323: -- ,jtf_rs_roles_b roles
324: -- WHERE res.resource_id = res_roles.role_resource_id
325: -- and res_roles.role_id=roles.role_id

Line 373: from jtf_rs_resource_extns res

369:
370:
371: CURSOR csr_agents IS
372: select res.resource_id
373: from jtf_rs_resource_extns res
374: ,jtf_rs_role_relations res_roles
375: ,jtf_rs_roles_b roles
376: where res.resource_id = res_roles.role_resource_id
377: and res_roles.role_resource_type = 'RS_INDIVIDUAL'

Line 399: -- FROM jtf_rs_resource_extns res

395: and nvl(a.end_date_active,sysdate)>=sysdate );
396:
397: -- Changed 09/12/02 rajayara
398: -- SELECT distinct res.resource_id
399: -- FROM jtf_rs_resource_extns res
400: -- ,jtf_rs_role_relations res_roles
401: -- ,jtf_rs_roles_b roles
402: -- WHERE res.resource_id = res_roles.role_resource_id
403: -- and res_roles.role_id=roles.role_id

Line 474: 'FROM jtf_rs_resource_extns res '||

470: END IF;
471:
472: l_default_select :=
473: 'SELECT distinct res.resource_id '||
474: 'FROM jtf_rs_resource_extns res '||
475: ' ,jtf_rs_role_relations res_roles '||
476: ' ,jtf_rs_roles_b roles '||
477: 'WHERE res.resource_id = res_roles.role_resource_id '||
478: 'and res_roles.role_id=roles.role_id '||

Line 549: 'FROM jtf_rs_resource_extns res '||

545: END IF;
546:
547: l_default_select :=
548: 'SELECT distinct res.resource_id '||
549: 'FROM jtf_rs_resource_extns res '||
550: ' ,jtf_rs_role_relations res_roles '||
551: ' ,jtf_rs_roles_b roles '||
552: 'WHERE res.resource_id = res_roles.role_resource_id '||
553: 'and res_roles.role_id=roles.role_id '||