213: CLOSE csr_get_asg_details;
214:
215: END IF;
216:
217: p_tax_unit_id := nvl( hr_mx_utility.get_GRE_from_scl(l_hsck_id),
218:
219: hr_mx_utility.get_gre_from_location(l_location_id,
220: l_bg_id,
221: p_effective_date,
215: END IF;
216:
217: p_tax_unit_id := nvl( hr_mx_utility.get_GRE_from_scl(l_hsck_id),
218:
219: hr_mx_utility.get_gre_from_location(l_location_id,
220: l_bg_id,
221: p_effective_date,
222: l_ambiguous_flag,
223: l_missing_flag )
735:
736: hr_utility_trace('ln_bus_grp_id '|| ln_bus_grp_id);
737:
738: ln_legal_employer_id :=
739: hr_mx_utility.get_legal_employer(ln_bus_grp_id, ln_tax_unit_id);
740: hr_utility_trace('ln_legal_employer_id '|| ln_legal_employer_id);
741:
742:
743: OPEN c_get_employer_information(ln_legal_employer_id);