[Home] [Help]
3029: -- 115.57 (START)
3030: --
3031: --select pos.final_process_date
3032: select pos.actual_termination_date,
3033: pos.last_standard_process_date,
3034: pos.final_process_date
3035: --
3036: -- 115.57 (END)
3037: --
3042: -- 115.57 (START)
3043: --
3044: l_fpd per_periods_of_service.final_process_date%TYPE;
3045: l_atd per_periods_of_service.actual_termination_date%TYPE;
3046: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3047: --
3048: -- Cursor to get legislation code
3049: --
3050: CURSOR csr_per_legislation
3391: if g_debug then
3392: hr_utility.set_location(l_proc, 25);
3393: end if;
3394: --
3395: -- create a default primary assignment with any corresponding standard
3396: -- element entries for the re-hired employee
3397: --
3398: hr_assignment_internal.create_default_emp_asg
3399: (p_effective_date => l_hire_date,
4127: -- 115.57 (START)
4128: --
4129: --select pos.final_process_date
4130: select pos.actual_termination_date,
4131: pos.last_standard_process_date,
4132: pos.final_process_date
4133: --
4134: -- 115.57 (END)
4135: --
4140: -- 115.57 (START)
4141: --
4142: l_fpd per_periods_of_service.final_process_date%TYPE;
4143: l_atd per_periods_of_service.actual_termination_date%TYPE;
4144: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
4145: l_rule_value pay_legislation_rules.rule_mode%TYPE;
4146: l_rule_found BOOLEAN;
4147: --
4148: -- 115.57 (END)
5547: CURSOR csr_prev_pds IS
5548: SELECT pds.period_of_service_id
5549: ,pds.date_start
5550: ,pds.actual_termination_date
5551: ,pds.last_standard_process_date
5552: ,pds.final_process_date
5553: FROM per_periods_of_service pds
5554: WHERE pds.person_id = p_person_id
5555: AND pds.date_start < p_rehire_date