DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_SITE_GROUP_VERSIONS

Line 1397: FROM RRS_SITE_GROUP_VERSIONS curVer

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:

Line 1424: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =

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: