APPS.RRS_HIERARCHY_INFO dependencies on RRS_SITE_GROUPS_VL

Line 121: FROM RRS_SITE_GROUPS_VL

117: END IF;
118:
119: SELECT SITE_GROUP_ID
120: INTO l_hier_id
121: FROM RRS_SITE_GROUPS_VL
122: WHERE NAME = p_hier_name;
123:
124: Get_Hierarchy_Header(p_api_version => p_api_version
125: ,p_hier_id => l_hier_id

Line 433: FROM RRS_SITE_GROUPS_VL

429: /* get site_group_id from hier name*/
430: BEGIN
431: SELECT SITE_GROUP_ID
432: INTO l_hier_id
433: FROM RRS_SITE_GROUPS_VL
434: WHERE NAME = p_hier_name;
435: EXCEPTION
436: WHEN NO_DATA_FOUND THEN
437: RAISE e_no_hierarchy_found;

Line 551: FROM RRS_SITE_GROUPS_VL RSG, RRS_SITE_GROUP_VERSIONS RSGV

547: /* get site_group_id*/
548: BEGIN
549: SELECT RSG.SITE_GROUP_ID, RSG.GROUP_PURPOSE_CODE
550: INTO l_site_group_id, l_group_purpose_code
551: FROM RRS_SITE_GROUPS_VL RSG, RRS_SITE_GROUP_VERSIONS RSGV
552: WHERE RSG.SITE_GROUP_ID = RSGV.SITE_GROUP_ID
553: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id;
554: EXCEPTION
555: WHEN NO_DATA_FOUND THEN

Line 804: FROM RRS_SITE_GROUPS_VL

800: -- get site_group_id
801: BEGIN
802: SELECT SITE_GROUP_ID
803: INTO l_hier_id
804: FROM RRS_SITE_GROUPS_VL
805: WHERE NAME = p_hier_name;
806: EXCEPTION
807: WHEN NO_DATA_FOUND THEN
808: RAISE e_no_hierarchy_found;