1393: WHERE SiteGroupMemberEO.SITE_GROUP_ID = SiteGroup.SITE_GROUP_ID
1394: AND SiteGroup.SITE_GROUP_TYPE_CODE = 'C'
1395: AND SiteGroupMemberEO.SITE_GROUP_VERSION_ID =
1396: (SELECT MAX(SITE_GROUP_VERSION_ID)
1397: FROM RRS_SITE_GROUP_VERSIONS curVer
1398: WHERE curVer.SITE_GROUP_ID = SiteGroupMemberEO.SITE_GROUP_ID)
1399: AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1400: AND DELETED_FLAG = 'N';
1401:
1420: WHERE SiteGroupMemberEO.SITE_GROUP_ID = SiteGroup.SITE_GROUP_ID
1421: AND SiteGroup.SITE_GROUP_TYPE_CODE = 'H'
1422: AND SiteGroupNode.site_group_node_id = SiteGroupMemberEO.PARENT_MEMBER_ID
1423: AND SiteGroupMemberEO.SITE_GROUP_VERSION_ID = (SELECT MAX(SITE_GROUP_VERSION_ID)
1424: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =
1425: SiteGroupMemberEO.SITE_GROUP_ID) AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1426: AND DELETED_FLAG = 'N';
1427:
1428: