12035: and GTT.OWNER_TYPE_ACTUAL = 'RS_GROUP'
12036: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')
12037: and asg.assignee_role = 'ASSIGNEE'
12038: and exists
12039: (SELECT /*+ index(a,JTF_RS_GROUP_MEMBERS_N1) */ null
12040: FROM JTF_RS_GROUP_MEMBERS a
12041: WHERE a.group_id= GTT.owner_id
12042: and a.RESOURCE_ID = asg.resource_id
12043: AND NVL(DELETE_FLAG,'N') <> 'Y' )
12036: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')
12037: and asg.assignee_role = 'ASSIGNEE'
12038: and exists
12039: (SELECT /*+ index(a,JTF_RS_GROUP_MEMBERS_N1) */ null
12040: FROM JTF_RS_GROUP_MEMBERS a
12041: WHERE a.group_id= GTT.owner_id
12042: and a.RESOURCE_ID = asg.resource_id
12043: AND NVL(DELETE_FLAG,'N') <> 'Y' )
12044: and exists