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'
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
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
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)
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'
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 = to_char(p_tax_unit_id)
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