APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUPS_VL

Line 41: FROM RRS_SITE_GROUPS_VL

37:
38: BEGIN
39: SELECT SITE_GROUP_ID
40: INTO v_hier_id
41: FROM RRS_SITE_GROUPS_VL
42: WHERE NAME = p_name;
43: EXCEPTION
44: WHEN NO_DATA_FOUND THEN
45: --RRS_NO_HIER_FOUND

Line 1601: FROM RRS_SITE_GROUPS_VL RSGV

1597:
1598: BEGIN
1599: SELECT SITE_GROUP_ID
1600: INTO v_hier_id
1601: FROM RRS_SITE_GROUPS_VL RSGV
1602: WHERE RSGV.NAME = p_hier_name;
1603: EXCEPTION
1604: WHEN NO_DATA_FOUND THEN
1605: --RRS_NO_HIER_FOUND

Line 1810: FROM RRS_SITE_GROUPS_VL RSGV

1806: --get dest hier id
1807: BEGIN
1808: SELECT SITE_GROUP_ID, GROUP_PURPOSE_CODE
1809: INTO v_dest_hier_id, v_dest_hier_purpose_code
1810: FROM RRS_SITE_GROUPS_VL RSGV
1811: WHERE RSGV.NAME = p_hier_members_rec.dest_hier_name;
1812: EXCEPTION
1813: WHEN NO_DATA_FOUND THEN
1814: --RRS_NO_HIER_FOUND

Line 2093: FROM RRS_SITE_GROUPS_VL

2089: --get source hier id
2090: BEGIN
2091: SELECT SITE_GROUP_ID
2092: INTO v_source_hier_id
2093: FROM RRS_SITE_GROUPS_VL
2094: WHERE NAME = p_hier_members_rec.source_hier_name;
2095: EXCEPTION
2096: WHEN NO_DATA_FOUND THEN
2097: --RRS_NO_HIER_FOUND

Line 2406: FROM RRS_SITE_GROUPS_VL RSGV

2402: --get hier purpose code
2403: BEGIN
2404: SELECT GROUP_PURPOSE_CODE
2405: INTO v_hier_purpose_code
2406: FROM RRS_SITE_GROUPS_VL RSGV
2407: WHERE RSGV.SITE_GROUP_ID = p_hier_id;
2408: EXCEPTION
2409: WHEN NO_DATA_FOUND THEN
2410: --RRS_NO_HIER_ID_FOUND

Line 2512: FROM RRS_SITE_GROUPS_VL RSGV

2508: --get hier purpose code
2509: BEGIN
2510: SELECT GROUP_PURPOSE_CODE, NAME
2511: INTO v_hier_purpose_code, v_hier_name
2512: FROM RRS_SITE_GROUPS_VL RSGV
2513: WHERE RSGV.SITE_GROUP_ID = p_hier_id;
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: --RRS_NO_HIER_ID_FOUND