APPS.RRS_HIERARCHY_INFO dependencies on RRS_SITE_GROUP_MEMBERS

Line 169: l_parent_id rrs_site_group_members.parent_member_id%TYPE;

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;
172:
173:

Line 280: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMembers,

276: LEVEL
277: )
278: BULK COLLECT
279: INTO x_hier_members_tab
280: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMembers,
281: RRS_SITE_GROUP_NODES_VL SiteGroupNodes1,
282: RRS_SITE_GROUP_NODES_VL SiteGroupNodes2,
283: RRS_SITES_VL Sites1,
284: RRS_SITES_VL Sites2

Line 422: l_parent_id rrs_site_group_members.parent_member_id%TYPE;

418: ,x_msg_data OUT NOCOPY varchar2
419: ) is
420:
421: l_hier_id number;
422: l_parent_id rrs_site_group_members.parent_member_id%TYPE;
423:
424: BEGIN
425: IF x_msg_count IS NULL THEN
426: x_msg_count := 0;