117: p_final_process_date in date) is
118: select pueo.emp_city_tax_rule_id,
119: pueo.effective_start_date,
120: pueo.effective_end_date
121: from pay_us_emp_city_tax_rules_f pueo
122: where pueo.assignment_id = p_assignment_id
123: and pueo.effective_start_date = (select max(puei.effective_start_date)
124: from pay_us_emp_city_tax_rules_f puei
125: where puei.assignment_id = pueo.assignment_id
120: pueo.effective_end_date
121: from pay_us_emp_city_tax_rules_f pueo
122: where pueo.assignment_id = p_assignment_id
123: and pueo.effective_start_date = (select max(puei.effective_start_date)
124: from pay_us_emp_city_tax_rules_f puei
125: where puei.assignment_id = pueo.assignment_id
126: and puei.state_code = pueo.state_code
127: and puei.county_code = pueo.county_code
128: and puei.city_code = pueo.city_code
151: l_assignment_id per_assignments_f.assignment_id%type ;
152: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%type ;
153: l_emp_st_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%type ;
154: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%type ;
155: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%type ;
156: l_eff_st_dt date ;
157: l_eff_end_dt date ;
158: l_dummy varchar2(1) ;
159:
249: exit when c_get_citytax_rules%NOTFOUND ;
250: hr_utility.trace('l_emp_city_tax_rule_id := '||l_emp_city_tax_rule_id) ;
251:
252: -- Updating City Tax Rules
253: update pay_us_emp_city_tax_rules_f
254: set effective_end_date = l_final_process_date
255: where emp_city_tax_rule_id = l_emp_city_tax_rule_id
256: and effective_start_date = l_eff_st_dt
257: and effective_end_date = l_eff_end_dt ;