eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_STRUCT_SUMMARY dependencies on PER_GEN_HIERARCHY

Line 90: FROM per_gen_hierarchy_nodes ghn

86: (cp_gen_hierarchy_version_id NUMBER)
87: IS
88:
89: SELECT ghn.entity_id top_entity_id
90: FROM per_gen_hierarchy_nodes ghn
91: WHERE ghn.hierarchy_version_id = cp_gen_hierarchy_version_id
92: AND ghn.parent_hierarchy_node_id is null;
93:
94: --Return value

Line 211: FROM per_gen_hierarchy ghr

207: , ghv.date_from
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

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 222: ,cp_top_entity_id per_gen_hierarchy_nodes.entity_id%type ) -- 2492438

218: -- cursor walks down the tree to give all parent entities in a tree
219: -- and the level number where the top entity is 1.
220: CURSOR csr_gen_parents
221: (cp_gen_hierarchy_version_id NUMBER
222: ,cp_top_entity_id per_gen_hierarchy_nodes.entity_id%type ) -- 2492438
223: IS
224: -- cursor walks down the tree to give all parent entities in a tree
225: -- and the level number where the top entity is 1.
226: SELECT ghn.business_group_id business_group_id

Line 231: FROM per_gen_hierarchy_nodes ghn

227: , ghn.hierarchy_node_id hierarchy_node_id
228: , ghn.entity_id entity_id
229: , LEVEL entity_level
230: , ghn.node_type node_type
231: FROM per_gen_hierarchy_nodes ghn
232: WHERE ghn.hierarchy_version_id = cp_gen_hierarchy_version_id
233: START WITH ghn.entity_id = cp_top_entity_id
234: CONNECT BY ghn.parent_hierarchy_node_id = PRIOR ghn.hierarchy_node_id
235: -- Note: this looks excessive but making sure both

Line 246: ,cp_top_entity_id per_gen_hierarchy_nodes.entity_id%type ) -- 2492438

242: -- cursor walks down the tree to give all children in the tree
243: -- and the number of levels away from the top entity
244: CURSOR csr_gen_children
245: (cp_gen_hierarchy_version_id NUMBER
246: ,cp_top_entity_id per_gen_hierarchy_nodes.entity_id%type ) -- 2492438
247: IS
248: SELECT ghn.business_group_id business_group_id
249: , ghn.hierarchy_node_id hierarchy_node_id
250: , ghn.entity_id entity_id

Line 253: FROM per_gen_hierarchy_nodes ghn

249: , ghn.hierarchy_node_id hierarchy_node_id
250: , ghn.entity_id entity_id
251: , LEVEL -1 entity_level
252: , ghn.node_type node_type
253: FROM per_gen_hierarchy_nodes ghn
254: WHERE ghn.hierarchy_version_id = cp_gen_hierarchy_version_id
255: START WITH ghn.entity_id = cp_top_entity_id
256: CONNECT BY ghn.parent_hierarchy_node_id = PRIOR ghn.hierarchy_node_id
257: -- Note: this looks excessive but making sure both

Line 269: (business_group_id per_gen_hierarchy.business_group_id%TYPE

265: -- Local Variables
266: ---------------------
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

Line 270: ,hierarchy_id per_gen_hierarchy.hierarchy_id%TYPE

266: ---------------------
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: );

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;