[Home] [Help]
7880: -- Final process date of employee if he/she
7881: -- has been terminated with in the reporting period and
7882: -- sums up salary paid upto Final close Date.
7883: -- NB: If for a terminated employee there is no Final Close Date
7884: -- then it picks up the Last Standard Process Date if it exists, else
7885: -- (ie. LSP date is Null and Final Close Date is Null ) then it picks up the
7886: -- actual Termination Date. Since no upper bound for payroll date
7887: -- is found the payments are done till actual termination date
7888: -- which is calculated as per adjust_post_part_payments.
7932: debug('actual_termination_date: '||
7933: to_char(l_get_term_details.actual_termination_date,'DD-MM-YYYY'),20);
7934:
7935: l_term_proc_date := NVL(l_get_term_details.final_process_date ,
7936: NVL(l_get_term_details.last_standard_process_date,
7937: l_get_term_details.actual_termination_date));
7938:
7939: IF l_term_proc_date <> l_get_term_details.actual_termination_date THEN
7940: l_terminated := 'Y'; -- flag to check employee being terminated.
7966: -- If there is a case where person is terminated and
7967: -- there is no pay period after that current month then
7968: -- p_effective start_date is NULL after pre_payment is done.
7969: -- In that case if any days exist between terminated day and
7970: -- Last Standard process date then we want to calculate
7971: -- the terminated payment as well by setting the effective start date
7972: -- to p_effective_end_date.
7973:
7974: -- IF p_effective_start_date is NULL THEN