[Home] [Help]
281: where asg.assignment_id = p_assignment_id
282: and asg.assignment_status_type_id=ast.assignment_status_type_id
283: and ast.per_system_status='ACTIVE_ASSIGN';
284:
285: -- Modified the cursor below to retrieve the last_standard_process_date
286: -- and actual_termination_date along with the final_process_date
287: -- as part of the fix for Bug 4073821
288: --
289: cursor csr_pds_final_process_date is
287: -- as part of the fix for Bug 4073821
288: --
289: cursor csr_pds_final_process_date is
290: select final_process_date,
291: last_standard_process_date,
292: actual_termination_date
293: from per_periods_of_service pds
294: , per_all_assignments_f asg
295: where asg.assignment_id=p_assignment_id
339: l_effective_end_date date;
340: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
341: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;
342: --4073821
343: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;
344: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
345: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;
346:
347: l_proc varchar2(72) := g_package||'chk_pay_basis_change_date';
422: end if;
423: ELSIF NVL(l_ele_term_rule,'F') = 'L' THEN
424: --
425: -- Element does not end on the day that the assignment ends, but
426: -- could end on the last standard process date
427: --
428: hr_utility.set_location(l_proc,26);
429: if (l_pds_last_std_proc_date <> l_effective_end_date) or
430: (l_pds_last_std_proc_date is null) then