SELECT A.SLS_GROUP SLS_GROUP , A.SLS_ALLOCATION TABLE_NAME FROM IGI_SLS_ALLOCATIONS A , IGI_SLS_SECURE_TABLES B , IGI_SLS_GROUPS C WHERE A.SLS_GROUP = C.SLS_GROUP AND A.SLS_GROUP_TYPE = 'S' AND A.SLS_ALLOCATION = B.TABLE_NAME AND A.SLS_ALLOCATION_TYPE = 'T' AND C.SLS_GROUP_TYPE = 'S' AND A.DATE_REMOVED IS NULL AND A.DATE_DISABLED IS NULL AND B.DATE_REMOVED IS NULL AND B.DATE_DISABLED IS NULL AND C.DATE_REMOVED IS NULL AND C.DATE_DISABLED IS NULL UNION SELECT A.SLS_GROUP SLS_GROUP , D.SLS_ALLOCATION TABLE_NAME FROM IGI_SLS_ALLOCATIONS A , IGI_SLS_SECURE_TABLES B , IGI_SLS_GROUPS C , IGI_SLS_ALLOCATIONS D , IGI_SLS_GROUPS E WHERE A.SLS_GROUP = C.SLS_GROUP AND A.SLS_GROUP_TYPE = 'S' AND A.SLS_ALLOCATION_TYPE = 'P' AND C.SLS_GROUP_TYPE = 'S' AND A.SLS_ALLOCATION = D.SLS_GROUP AND D.SLS_GROUP_TYPE = 'P' AND D.SLS_GROUP = E.SLS_GROUP AND D.SLS_GROUP_TYPE = 'P' AND D.SLS_ALLOCATION = B.TABLE_NAME AND D.SLS_ALLOCATION_TYPE = 'T' AND E.SLS_GROUP_TYPE = 'P' AND A.DATE_REMOVED IS NULL AND A.DATE_DISABLED IS NULL AND B.DATE_REMOVED IS NULL AND B.DATE_DISABLED IS NULL AND C.DATE_REMOVED IS NULL AND C.DATE_DISABLED IS NULL AND D.DATE_REMOVED IS NULL AND D.DATE_DISABLED IS NULL AND E.DATE_REMOVED IS NULL AND E.DATE_DISABLED IS NULL