APPS.HR_US_PERSON_TERM_LEG_HOOK dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 104: from pay_us_emp_county_tax_rules_f pueo

100: p_final_process_date in date) is
101: select pueo.emp_county_tax_rule_id,
102: pueo.effective_start_date,
103: pueo.effective_end_date
104: from pay_us_emp_county_tax_rules_f pueo
105: where pueo.assignment_id = p_assignment_id
106: and pueo.effective_start_date = (select max(puei.effective_start_date)
107: from pay_us_emp_county_tax_rules_f puei
108: where puei.assignment_id = pueo.assignment_id

Line 107: from pay_us_emp_county_tax_rules_f puei

103: pueo.effective_end_date
104: from pay_us_emp_county_tax_rules_f pueo
105: where pueo.assignment_id = p_assignment_id
106: and pueo.effective_start_date = (select max(puei.effective_start_date)
107: from pay_us_emp_county_tax_rules_f puei
108: where puei.assignment_id = pueo.assignment_id
109: and puei.state_code = pueo.state_code
110: and puei.county_code = pueo.county_code
111: and puei.effective_start_date <= p_final_process_date) ;

Line 154: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%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 ;
158: l_dummy varchar2(1) ;

Line 237: update pay_us_emp_county_tax_rules_f

233: exit when c_get_countytax_rules%NOTFOUND ;
234: hr_utility.trace('l_emp_county_tax_rule_id := '||l_emp_county_tax_rule_id) ;
235:
236: -- Updating County Tax Rules
237: update pay_us_emp_county_tax_rules_f
238: set effective_end_date = l_final_process_date
239: where emp_county_tax_rule_id = l_emp_county_tax_rule_id
240: and effective_start_date = l_eff_st_dt
241: and effective_end_date = l_eff_end_dt ;