DBA Data[Home] [Help]

APPS.HR_MX_UTILITY dependencies on PER_GEN_HIERARCHY_VERSIONS

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 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 = to_char(p_tax_unit_id)
448: AND gre_node.business_group_id = p_business_group_id