APPS.HRI_STRUCT_SUMMARY dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 212: , per_gen_hierarchy_versions ghv

208: , ghv.date_to
209: , ghv.version_number
210: , ghr.name
211: FROM per_gen_hierarchy ghr
212: , per_gen_hierarchy_versions ghv
213: WHERE ghr.hierarchy_id = ghv.hierarchy_id
214: AND ghr.business_group_id = ghv.business_group_id
215: AND ghr.type = 'FEDREP'; -- bug 2492438
216: -- bug 2834215 performance improvement removed order by

Line 271: ,hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE

267:
268: TYPE t_gen_struct_ver_rec IS RECORD
269: (business_group_id per_gen_hierarchy.business_group_id%TYPE
270: ,hierarchy_id per_gen_hierarchy.hierarchy_id%TYPE
271: ,hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE
272: ,date_from per_gen_hierarchy_versions.date_from%TYPE
273: ,date_to per_gen_hierarchy_versions.date_to%TYPE
274: );
275:

Line 272: ,date_from per_gen_hierarchy_versions.date_from%TYPE

268: TYPE t_gen_struct_ver_rec IS RECORD
269: (business_group_id per_gen_hierarchy.business_group_id%TYPE
270: ,hierarchy_id per_gen_hierarchy.hierarchy_id%TYPE
271: ,hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE
272: ,date_from per_gen_hierarchy_versions.date_from%TYPE
273: ,date_to per_gen_hierarchy_versions.date_to%TYPE
274: );
275:
276: l_gen_struct_ver_rec t_gen_struct_ver_rec;

Line 273: ,date_to per_gen_hierarchy_versions.date_to%TYPE

269: (business_group_id per_gen_hierarchy.business_group_id%TYPE
270: ,hierarchy_id per_gen_hierarchy.hierarchy_id%TYPE
271: ,hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE
272: ,date_from per_gen_hierarchy_versions.date_from%TYPE
273: ,date_to per_gen_hierarchy_versions.date_to%TYPE
274: );
275:
276: l_gen_struct_ver_rec t_gen_struct_ver_rec;
277: l_top_entity NUMBER;