32:
33: cursor c_get_person_oldfpd(p_period_of_service_id in number) is
34: select distinct pds.person_id,
35: pds.final_process_date
36: from per_periods_of_service pds
37: where pds.period_of_service_id = p_period_of_service_id ;
38:
39: /* Getting all Terminated Assignments for the Person concerned */
40:
134: SELECT NULL
135: FROM pay_payroll_actions ppa
136: ,pay_assignment_actions paa
137: ,per_assignments_f asg
138: ,per_periods_of_service pds
139: WHERE pds.period_of_service_id = p_period_of_service_id
140: AND pds.person_id = asg.person_id
141: AND asg.period_of_service_id = pds.period_of_service_id
142: AND asg.assignment_id = paa.assignment_id
145: AND ppa.effective_date > p_new_final_process_date ;
146:
147:
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 ;
146:
147:
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 ;