APPS.HR_US_PERSON_TERM_LEG_HOOK dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 72: from pay_us_emp_fed_tax_rules_f pueo

68: p_final_process_date in date) is
69: select pueo.emp_fed_tax_rule_id,
70: pueo.effective_start_date,
71: pueo.effective_end_date
72: from pay_us_emp_fed_tax_rules_f pueo
73: where pueo.assignment_id = p_assignment_id
74: and pueo.effective_start_date = (select max(puei.effective_start_date)
75: from pay_us_emp_fed_tax_rules_f puei
76: where puei.assignment_id = pueo.assignment_id

Line 75: from pay_us_emp_fed_tax_rules_f puei

71: pueo.effective_end_date
72: from pay_us_emp_fed_tax_rules_f pueo
73: where pueo.assignment_id = p_assignment_id
74: and pueo.effective_start_date = (select max(puei.effective_start_date)
75: from pay_us_emp_fed_tax_rules_f puei
76: where puei.assignment_id = pueo.assignment_id
77: and puei.effective_start_date <= p_final_process_date) ;
78:
79: -- Fetching State Tax Rules details for the latest record for each state

Line 152: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%type ;

148: l_person_id per_people_f.person_id%type ;
149: l_old_fpd per_periods_of_service.final_process_date%type ;
150: l_final_process_date per_periods_of_service.final_process_date%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 ;

Line 207: update pay_us_emp_fed_tax_rules_f

203: exit when c_get_fedtax_rules%NOTFOUND ;
204: hr_utility.trace('l_emp_fed_tax_rule_id := '||l_emp_fed_tax_rule_id) ;
205:
206: -- Updating Fed Tax Rules
207: update pay_us_emp_fed_tax_rules_f
208: set effective_end_date = l_final_process_date
209: where emp_fed_tax_rule_id = l_emp_fed_tax_rule_id
210: and effective_start_date = l_eff_st_dt
211: and effective_end_date = l_eff_end_dt ;