234: ,p_effective_date => p_date_earned ));
235:
236: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
237: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
238: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
239: else
240: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
241: end if;
242:
236: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
237: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
238: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
239: else
240: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
241: end if;
242:
243: end if;
244:
319: ,p_effective_date => p_date_earned ));
320:
321: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
322: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
323: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
324: else
325: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
326: end if;
327:
321: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
322: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
323: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
324: else
325: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
326: end if;
327:
328: if l_months >= 1 then
329: l_amt := l_mth_amt;
468: ,p_effective_date => p_date_earned ));
469:
470: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
471: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
472: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
473: else
474: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
475: end if;
476:
470: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
471: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
472: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
473: else
474: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
475: end if;
476:
477: end if;
478:
553: ,p_effective_date => p_date_earned ));
554:
555: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
556: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
557: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
558: else
559: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
560: end if;
561:
555: /* Bug-11880310 : l_dly_amt calculation logic is changed as per requirement */
556: If ( p_date_earned >= to_date('2011/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) then
557: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);
558: else
559: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);
560: end if;
561:
562: if l_months >= 1 then
563: l_amt := l_mth_amt;
745:
746: hr_utility.trace('l_proc_start_date:'||to_char(l_proc_start_date,'YYYY/MM/DD'));
747:
748: if p_cpf_pro_method = 'C' then
749: l_total_days := fffunc.days_between(p_pay_proc_end_date , p_pay_proc_start_date)+1;
750: elsif p_cpf_pro_method = 'WC' then
751: l_inputs(1).name := 'CPF_START_DATE';
752: l_inputs(1).value := p_pay_proc_start_date;
753: l_inputs(2).name := 'CPF_END_DATE';
842: end if;
843:
844: if l_pro_check = 'Y' then
845: if p_cpf_pro_method = 'C' then
846: l_days := fffunc.days_between(l_proc_end_date , l_proc_start_date)+1;
847: elsif p_cpf_pro_method = 'WC' then
848: l_inputs(1).name := 'CPF_START_DATE';
849: l_inputs(1).value := l_proc_start_date;
850: l_inputs(2).name := 'CPF_END_DATE';