APPS.RRS_HIERARCHY_INFO dependencies on RRS_SITE_GROUPS_B

Line 31: FROM RRS_SITE_GROUP_VERSIONS RSGV, RRS_SITE_GROUPS_B RSGB, RRS_SITE_GROUPS_TL RSGT, RRS_LOOKUPS_V LKUP

27: RSGT.DESCRIPTION,
28: RSGB.START_DATE,
29: RSGB.END_DATE)
30: INTO x_hier_header_rec
31: FROM RRS_SITE_GROUP_VERSIONS RSGV, RRS_SITE_GROUPS_B RSGB, RRS_SITE_GROUPS_TL RSGT, RRS_LOOKUPS_V LKUP
32: WHERE RSGT.LANGUAGE = userenv('LANG')
33: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id
34: AND RSGB.SITE_GROUP_ID = RSGV.SITE_GROUP_ID
35: AND RSGT.SITE_GROUP_ID = RSGB.SITE_GROUP_ID

Line 167: l_site_group_id rrs_site_groups_b.site_group_id%TYPE;

163: ,x_msg_count OUT NOCOPY number
164: ,x_msg_data OUT NOCOPY varchar2
165: ) is
166:
167: l_site_group_id rrs_site_groups_b.site_group_id%TYPE;
168: l_site_group_version_id rrs_site_group_versions.site_group_version_id%TYPE;
169: l_parent_id rrs_site_group_members.parent_member_id%TYPE;
170:
171: x_hier_header_rec rrs_hier_header_rec;