APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 36: jtf_rs_role_relations res_roles,

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
40: FROM per_competence_elements comp_ele,

Line 297: ,jtf_rs_role_relations res_roles

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'
301: and res_roles.start_date_active<=sysdate

Line 322: -- ,jtf_rs_role_relations res_roles

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
326: -- and (roles.role_type_code = 'CALLCENTER'

Line 374: ,jtf_rs_role_relations res_roles

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'
378: and res_roles.start_date_active<=sysdate

Line 400: -- ,jtf_rs_role_relations res_roles

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
404: -- and (roles.role_type_code = 'CALLCENTER'

Line 475: ' ,jtf_rs_role_relations res_roles '||

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 '||
479: 'and (roles.role_type_code = '||l_apos|| 'CALLCENTER' ||l_apos||

Line 550: ' ,jtf_rs_role_relations res_roles '||

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 '||
554: 'and (roles.role_type_code = '||l_apos|| 'CALLCENTER' ||l_apos||