APPS.RRS_HIERARCHY_INFO dependencies on RRS_HIER_MEMBERS_REC

Line 238: SELECT rrs_hier_members_rec(

234: -- For bug fix 9011360
235: -- Add SiteGroupId condition to the main SQL query, because the SiteGroupId is the first index column. This will fix the performance issue.
236: -- jijiao 10/13/2009
237: IF l_parent_id IS NOT NULL THEN
238: SELECT rrs_hier_members_rec(
239: SiteGroupMembers.SITE_GROUP_ID,
240: SiteGroupMembers.SITE_GROUP_VERSION_ID,
241: DECODE(SiteGroupMembers.PARENT_MEMBER_ID, -1, NULL, DECODE(SiteGroupNodes2.SITE_GROUP_NODE_ID, NULL, Sites2.SITE_ID,
242: SiteGroupNodes2.SITE_GROUP_NODE_ID)),