APPS.HR_CA_PERSON_TERM_LEG_HOOK dependencies on PER_PERIODS_OF_SERVICE

Line 34: from per_periods_of_service pds

30:
31: cursor c_get_person_oldfpd(p_period_of_service_id in number) is
32: select distinct pds.person_id,
33: pds.final_process_date
34: from per_periods_of_service pds
35: where pds.period_of_service_id = p_period_of_service_id ;
36:
37: /* Getting all Terminated Assignments for the Person concerned */
38:

Line 102: ,per_periods_of_service pds

98: SELECT NULL
99: FROM pay_payroll_actions ppa
100: ,pay_assignment_actions paa
101: ,per_assignments_f asg
102: ,per_periods_of_service pds
103: WHERE pds.period_of_service_id = p_period_of_service_id
104: AND pds.person_id = asg.person_id
105: AND asg.period_of_service_id = pds.period_of_service_id
106: AND asg.assignment_id = paa.assignment_id

Line 113: l_old_fpd per_periods_of_service.final_process_date%type ;

109: AND ppa.effective_date > p_new_final_process_date ;
110:
111:
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 ;

Line 114: l_final_process_date per_periods_of_service.final_process_date%type ;

110:
111:
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 ;