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.HR_MX_UTILITY dependencies on PER_GEN_HIERARCHY

Line 112: from per_gen_hierarchy pgh,

108: ) RETURN NUMBER IS
109:
110: CURSOR csr_get_GRE_from_loc IS
111: select distinct(pghn_gre.entity_id)
112: from per_gen_hierarchy pgh,
113: per_gen_hierarchy_versions pghv,
114: per_gen_hierarchy_nodes pghn_loc,
115: per_gen_hierarchy_nodes pghn_gre
116: where pgh.type = 'MEXICO HRMS'

Line 113: per_gen_hierarchy_versions pghv,

109:
110: CURSOR csr_get_GRE_from_loc IS
111: select distinct(pghn_gre.entity_id)
112: from per_gen_hierarchy pgh,
113: per_gen_hierarchy_versions pghv,
114: per_gen_hierarchy_nodes pghn_loc,
115: per_gen_hierarchy_nodes pghn_gre
116: where pgh.type = 'MEXICO HRMS'
117: and pghv.hierarchy_id = pgh.hierarchy_id

Line 114: per_gen_hierarchy_nodes pghn_loc,

110: CURSOR csr_get_GRE_from_loc IS
111: select distinct(pghn_gre.entity_id)
112: from per_gen_hierarchy pgh,
113: per_gen_hierarchy_versions pghv,
114: per_gen_hierarchy_nodes pghn_loc,
115: per_gen_hierarchy_nodes pghn_gre
116: where pgh.type = 'MEXICO HRMS'
117: and pghv.hierarchy_id = pgh.hierarchy_id
118: and p_session_date BETWEEN pghv.date_from

Line 115: per_gen_hierarchy_nodes pghn_gre

111: select distinct(pghn_gre.entity_id)
112: from per_gen_hierarchy pgh,
113: per_gen_hierarchy_versions pghv,
114: per_gen_hierarchy_nodes pghn_loc,
115: per_gen_hierarchy_nodes pghn_gre
116: where pgh.type = 'MEXICO HRMS'
117: and pghv.hierarchy_id = pgh.hierarchy_id
118: and p_session_date BETWEEN pghv.date_from
119: AND nvl(pghv.date_to, hr_general.end_of_time)

Line 442: FROM per_gen_hierarchy_nodes gre_node,

438: END IF;
439:
440: SELECT le_node.entity_id
441: INTO r_legal_employer_id
442: FROM per_gen_hierarchy_nodes gre_node,
443: per_gen_hierarchy_nodes le_node,
444: per_gen_hierarchy_versions hier_ver,
445: fnd_lookup_values lv
446: WHERE gre_node.node_type = 'MX GRE'

Line 443: per_gen_hierarchy_nodes le_node,

439:
440: SELECT le_node.entity_id
441: INTO r_legal_employer_id
442: FROM per_gen_hierarchy_nodes gre_node,
443: per_gen_hierarchy_nodes le_node,
444: per_gen_hierarchy_versions hier_ver,
445: fnd_lookup_values lv
446: WHERE gre_node.node_type = 'MX GRE'
447: AND gre_node.entity_id = p_tax_unit_id

Line 444: per_gen_hierarchy_versions hier_ver,

440: SELECT le_node.entity_id
441: INTO r_legal_employer_id
442: FROM per_gen_hierarchy_nodes gre_node,
443: per_gen_hierarchy_nodes le_node,
444: per_gen_hierarchy_versions hier_ver,
445: fnd_lookup_values lv
446: WHERE gre_node.node_type = 'MX GRE'
447: AND gre_node.entity_id = p_tax_unit_id
448: AND gre_node.business_group_id = p_business_group_id