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.PAY_US_MWR_REPORTING_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 377: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations

373: p_location_id number) IS
374: SELECT pghn2.entity_id
375: FROM per_gen_hierarchy pgh
376: ,per_gen_hierarchy_versions pghv
377: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
378: ,pay_payroll_actions ppa
379: where ppa.payroll_action_id = p_payroll_action_id
380: and pgh.hierarchy_id = p_est_hierarchy_id
381: and pgh.business_group_id = ppa.business_group_id

Line 392: FROM per_gen_hierarchy_nodes pghn3

388: OR
389: ( pghn2.node_type = 'EST'
390: AND p_location_id in
391: ( SELECT pghn3.entity_id
392: FROM per_gen_hierarchy_nodes pghn3
393: WHERE pghn3.node_type = 'LOC'
394: AND pghn3.hierarchy_version_id = pghv.HIERARCHY_VERSION_id
395: AND pghn3.parent_hierarchy_node_id = pghn2.hierarchy_node_id
396: )

Line 410: FROM per_gen_hierarchy_nodes pghn2 -- establishment organizations

406:
407: CURSOR c_derive_wksite_estab (p_hierarchy_ver_id number,
408: p_location_id number) IS
409: SELECT pghn2.entity_id
410: FROM per_gen_hierarchy_nodes pghn2 -- establishment organizations
411:
412: where p_hierarchy_ver_id = pghn2.hierarchy_version_id
413: and ( ( pghn2.node_type = 'EST'
414: and pghn2.entity_id = p_location_id

Line 420: FROM per_gen_hierarchy_nodes pghn3

416: OR
417: ( pghn2.node_type = 'EST'
418: AND p_location_id in
419: ( SELECT /*+ pghn3 PER_GEN_HIER_NOD_VER_N4 */ pghn3.entity_id
420: FROM per_gen_hierarchy_nodes pghn3
421: WHERE pghn3.node_type = 'LOC'
422: AND pghn3.hierarchy_version_id =
423: pghn2.hierarchy_version_id --p_hierarchy_ver_id
424: AND pghn3.parent_hierarchy_node_id =