APPS.HR_CA_PERSON_TERM_LEG_HOOK dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 86: from pay_ca_emp_prov_tax_info_f pueo

82: p_final_process_date in date) is
83: select pueo.emp_province_tax_inf_id,
84: pueo.effective_start_date,
85: pueo.effective_end_date
86: from pay_ca_emp_prov_tax_info_f pueo
87: where pueo.assignment_id = p_assignment_id
88: and pueo.effective_start_date = (select max(puei.effective_start_date)
89: from pay_ca_emp_prov_tax_info_f puei
90: where puei.assignment_id = pueo.assignment_id

Line 89: from pay_ca_emp_prov_tax_info_f puei

85: pueo.effective_end_date
86: from pay_ca_emp_prov_tax_info_f pueo
87: where pueo.assignment_id = p_assignment_id
88: and pueo.effective_start_date = (select max(puei.effective_start_date)
89: from pay_ca_emp_prov_tax_info_f puei
90: where puei.assignment_id = pueo.assignment_id
91: and puei.province_code = pueo.province_code
92: and puei.effective_start_date <= p_final_process_date) ;
93:

Line 117: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_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) ;
121:

Line 185: update pay_ca_emp_prov_tax_info_f

181: exit when c_get_provtax_rules%NOTFOUND ;
182: hr_utility.trace('l_emp_prov_tax_inf_id := '||l_emp_prov_tax_inf_id) ;
183:
184: -- Updating State Tax Rules
185: update pay_ca_emp_prov_tax_info_f
186: set effective_end_date = l_final_process_date
187: where emp_province_tax_inf_id = l_emp_prov_tax_inf_id
188: and effective_start_date = l_eff_st_dt
189: and effective_end_date = l_eff_end_dt ;