[Home] [Help]
2718: -- 115.57 (START)
2719: --
2720: --select pos.final_process_date
2721: select pos.actual_termination_date,
2722: pos.last_standard_process_date,
2723: pos.final_process_date
2724: --
2725: -- 115.57 (END)
2726: --
2731: -- 115.57 (START)
2732: --
2733: l_fpd per_periods_of_service.final_process_date%TYPE;
2734: l_atd per_periods_of_service.actual_termination_date%TYPE;
2735: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
2736: --
2737: -- Cursor to get legislation code
2738: --
2739: CURSOR csr_per_legislation
3079: if g_debug then
3080: hr_utility.set_location(l_proc, 25);
3081: end if;
3082: --
3083: -- create a default primary assignment with any corresponding standard
3084: -- element entries for the re-hired employee
3085: --
3086: hr_assignment_internal.create_default_emp_asg
3087: (p_effective_date => l_hire_date,
3815: -- 115.57 (START)
3816: --
3817: --select pos.final_process_date
3818: select pos.actual_termination_date,
3819: pos.last_standard_process_date,
3820: pos.final_process_date
3821: --
3822: -- 115.57 (END)
3823: --
3828: -- 115.57 (START)
3829: --
3830: l_fpd per_periods_of_service.final_process_date%TYPE;
3831: l_atd per_periods_of_service.actual_termination_date%TYPE;
3832: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3833: l_rule_value pay_legislation_rules.rule_mode%TYPE;
3834: l_rule_found BOOLEAN;
3835: --
3836: -- 115.57 (END)
5201: CURSOR csr_prev_pds IS
5202: SELECT pds.period_of_service_id
5203: ,pds.date_start
5204: ,pds.actual_termination_date
5205: ,pds.last_standard_process_date
5206: ,pds.final_process_date
5207: FROM per_periods_of_service pds
5208: WHERE pds.person_id = p_person_id
5209: AND pds.date_start < p_rehire_date