APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITES_B

Line 974: FROM RRS_SITES_B

970: WHERE PARENT_ID IS NOT NULL
971: AND ((PARENT_TYPE = 'SITE'
972: AND NOT EXISTS (
973: SELECT SITE_ID
974: FROM RRS_SITES_B
975: WHERE SITE_ID = RSGMT.PARENT_ID))
976: OR (PARENT_TYPE = 'NODE'
977: AND NOT EXISTS (
978: SELECT SITE_GROUP_NODE_ID

Line 989: FROM RRS_SITES_B

985: WHERE CHILD_ID IS NOT NULL
986: AND ((CHILD_TYPE = 'SITE'
987: AND NOT EXISTS (
988: SELECT SITE_ID
989: FROM RRS_SITES_B
990: WHERE SITE_ID = RSGMT.CHILD_ID))
991: OR (CHILD_TYPE = 'NODE'
992: AND NOT EXISTS (
993: SELECT SITE_GROUP_NODE_ID