[Home] [Help]
7931: -- Final process date of employee if he/she
7932: -- has been terminated with in the reporting period and
7933: -- sums up salary paid upto Final close Date.
7934: -- NB: If for a terminated employee there is no Final Close Date
7935: -- then it picks up the Last Standard Process Date if it exists, else
7936: -- (ie. LSP date is Null and Final Close Date is Null ) then it picks up the
7937: -- actual Termination Date. Since no upper bound for payroll date
7938: -- is found the payments are done till actual termination date
7939: -- which is calculated as per adjust_post_part_payments.
7983: debug('actual_termination_date: '||
7984: to_char(l_get_term_details.actual_termination_date,'DD-MM-YYYY'),20);
7985:
7986: l_term_proc_date := NVL(l_get_term_details.final_process_date ,
7987: NVL(l_get_term_details.last_standard_process_date,
7988: l_get_term_details.actual_termination_date));
7989:
7990: IF l_term_proc_date <> l_get_term_details.actual_termination_date THEN
7991: l_terminated := 'Y'; -- flag to check employee being terminated.
8017: -- If there is a case where person is terminated and
8018: -- there is no pay period after that current month then
8019: -- p_effective start_date is NULL after pre_payment is done.
8020: -- In that case if any days exist between terminated day and
8021: -- Last Standard process date then we want to calculate
8022: -- the terminated payment as well by setting the effective start date
8023: -- to p_effective_end_date.
8024:
8025: -- IF p_effective_start_date is NULL THEN