281: FROM JTF_RS_GROUP_MEMBERS mem,
282: JTF_RS_ROLE_RELATIONS rrel,
283: JTF_RS_ROLES_B role,
284: JTF_RS_GROUP_USAGES u,
285: JTF_RS_GROUPS_B grp
286: WHERE mem.group_member_id = rrel.role_resource_id
287: AND rrel.role_resource_type = 'RS_GROUP_MEMBER'
288: AND rrel.role_id = role.role_id
289: AND role.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')
878: FROM JTF_RS_GROUP_MEMBERS mem,
879: JTF_RS_ROLE_RELATIONS rrel,
880: JTF_RS_ROLES_B role,
881: JTF_RS_GROUP_USAGES u,
882: JTF_RS_GROUPS_B grp
883: WHERE mem.group_member_id = rrel.role_resource_id
884: AND rrel.role_resource_type = 'RS_GROUP_MEMBER'
885: AND rrel.role_id = role.role_id
886: AND role.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')