APPS.HR_CA_PERSON_TERM_LEG_HOOK dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 70: from pay_ca_emp_fed_tax_info_f pueo

66: p_final_process_date in date) is
67: select pueo.emp_fed_tax_inf_id,
68: pueo.effective_start_date,
69: pueo.effective_end_date
70: from pay_ca_emp_fed_tax_info_f pueo
71: where pueo.assignment_id = p_assignment_id
72: and pueo.effective_start_date = (select max(puei.effective_start_date)
73: from pay_ca_emp_fed_tax_info_f puei
74: where puei.assignment_id = pueo.assignment_id

Line 73: from pay_ca_emp_fed_tax_info_f puei

69: pueo.effective_end_date
70: from pay_ca_emp_fed_tax_info_f pueo
71: where pueo.assignment_id = p_assignment_id
72: and pueo.effective_start_date = (select max(puei.effective_start_date)
73: from pay_ca_emp_fed_tax_info_f puei
74: where puei.assignment_id = pueo.assignment_id
75: and puei.effective_start_date <= p_final_process_date) ;
76:
77:

Line 116: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%type ;

112: l_person_id per_people_f.person_id%type ;
113: l_old_fpd per_periods_of_service.final_process_date%type ;
114: l_final_process_date per_periods_of_service.final_process_date%type ;
115: l_assignment_id per_assignments_f.assignment_id%type ;
116: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%type ;
117: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%type ;
118: l_eff_st_dt date ;
119: l_eff_end_dt date ;
120: l_dummy varchar2(1) ;

Line 169: update pay_ca_emp_fed_tax_info_f

165: exit when c_get_fedtax_rules%NOTFOUND ;
166: hr_utility.trace('l_emp_fed_tax_inf_id := '||l_emp_fed_tax_inf_id) ;
167:
168: -- Updating Fed Tax Rules
169: update pay_ca_emp_fed_tax_info_f
170: set effective_end_date = l_final_process_date
171: where emp_fed_tax_inf_id = l_emp_fed_tax_inf_id
172: and effective_start_date = l_eff_st_dt
173: and effective_end_date = l_eff_end_dt ;