[Home] [Help]
420: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
421: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
422: (
423: SELECT m.group_id group_id, m.resource_id resource_id
424: FROM jtf_rs_group_members m,
425: jtf_rs_groups_b g,
426: jtf_rs_group_usages u,
427: jtf_rs_role_relations rr,
428: jtf_rs_roles_b r,
471: SELECT MIN(m.resource_id) resource_id,
472: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
473: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
474: MIN(res.source_id) person_id
475: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
476: jtf_rs_group_usages u, jtf_rs_role_relations rr,
477: jtf_rs_roles_b r, jtf_rs_resource_extns res,
478: (
479: SELECT tm.team_resource_id group_id,
678: (
679: SELECT MIN(m.resource_id) resource_id,
680: res.category resource_category,
681: m.group_id group_id, MIN(res.source_id) person_id
682: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
683: jtf_rs_group_usages u, jtf_rs_role_relations rr,
684: jtf_rs_roles_b r, jtf_rs_resource_extns res
685: WHERE m.group_id = g.group_id
686: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
2012: where aaa.sales_lead_id =w.trans_object_id);
2013:
2014: CURSOR c_get_group_id(c_resource_id NUMBER) IS
2015: SELECT grp.group_id
2016: FROM JTF_RS_GROUP_MEMBERS mem,
2017: JTF_RS_ROLE_RELATIONS rrel,
2018: JTF_RS_ROLES_B role,
2019: JTF_RS_GROUP_USAGES u,
2020: JTF_RS_GROUPS_B grp
2033: AND SYSDATE BETWEEN grp.start_date_active AND
2034: NVL(grp.end_date_active,SYSDATE)
2035: AND ROWNUM < 2;
2036:
2037: -- A resource may not be in any group. Besides, jtf_rs_group_members
2038: -- may not have person_id for all resources. Therefore, get person_id
2039: -- in this cursor, instead of in the above cursor.
2040: CURSOR c_get_person_id(c_resource_id NUMBER) IS
2041: SELECT res.source_id