85: and tasks.owner_type_code = 'RS_GROUP'
86: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')
87: and asg.assignee_role = 'ASSIGNEE'
88: and exists
89: (SELECT /*+ index(a,JTF_RS_GROUP_MEMBERS_N1) */ null
90: FROM JTF_RS_GROUP_MEMBERS a
91: WHERE a.group_id=tasks.owner_id
92: and a.RESOURCE_ID = asg.resource_id
93: AND NVL(DELETE_FLAG,'N') <> 'Y' )
86: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')
87: and asg.assignee_role = 'ASSIGNEE'
88: and exists
89: (SELECT /*+ index(a,JTF_RS_GROUP_MEMBERS_N1) */ null
90: FROM JTF_RS_GROUP_MEMBERS a
91: WHERE a.group_id=tasks.owner_id
92: and a.RESOURCE_ID = asg.resource_id
93: AND NVL(DELETE_FLAG,'N') <> 'Y' )
94: and exists
127: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')
128: and asg.assignee_role = 'ASSIGNEE'
129: and exists
130: (SELECT null
131: FROM JTF_RS_GROUP_MEMBERS
132: WHERE group_id=tasks.owner_id
133: and RESOURCE_ID = asg.resource_id
134: AND NVL(DELETE_FLAG,'N') <> 'Y' )
135: and exists