APPS.HR_US_PERSON_TERM_LEG_HOOK dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 121: from pay_us_emp_city_tax_rules_f pueo

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

Line 124: from pay_us_emp_city_tax_rules_f puei

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

Line 155: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%type ;

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:

Line 253: update pay_us_emp_city_tax_rules_f

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 ;