APPS.HR_US_PERSON_TERM_LEG_HOOK dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 88: from pay_us_emp_state_tax_rules_f pueo

84: p_final_process_date in date) is
85: select pueo.emp_state_tax_rule_id,
86: pueo.effective_start_date,
87: pueo.effective_end_date
88: from pay_us_emp_state_tax_rules_f pueo
89: where pueo.assignment_id = p_assignment_id
90: and pueo.effective_start_date = (select max(puei.effective_start_date)
91: from pay_us_emp_state_tax_rules_f puei
92: where puei.assignment_id = pueo.assignment_id

Line 91: from pay_us_emp_state_tax_rules_f puei

87: pueo.effective_end_date
88: from pay_us_emp_state_tax_rules_f pueo
89: where pueo.assignment_id = p_assignment_id
90: and pueo.effective_start_date = (select max(puei.effective_start_date)
91: from pay_us_emp_state_tax_rules_f puei
92: where puei.assignment_id = pueo.assignment_id
93: and puei.state_code = pueo.state_code
94: and puei.effective_start_date <= p_final_process_date) ;
95:

Line 153: l_emp_st_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_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 ;
157: l_eff_end_dt date ;

Line 222: update pay_us_emp_state_tax_rules_f

218: exit when c_get_statetax_rules%NOTFOUND ;
219: hr_utility.trace('l_emp_st_tax_rule_id := '||l_emp_st_tax_rule_id) ;
220:
221: -- Updating State Tax Rules
222: update pay_us_emp_state_tax_rules_f
223: set effective_end_date = l_final_process_date
224: where emp_state_tax_rule_id = l_emp_st_tax_rule_id
225: and effective_start_date = l_eff_st_dt
226: and effective_end_date = l_eff_end_dt ;