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