DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on FFFUNC

Line 238: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);

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:

Line 240: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);

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:

Line 323: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);

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:

Line 325: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);

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;

Line 472: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);

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:

Line 474: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);

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:

Line 557: l_dly_amt := fffunc.round_up(l_mth_amt*12/365,2);

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:

Line 559: l_dly_amt := fffunc.round_up(l_mth_amt/30,0);

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;

Line 749: l_total_days := fffunc.days_between(p_pay_proc_end_date , p_pay_proc_start_date)+1;

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';

Line 846: l_days := fffunc.days_between(l_proc_end_date , l_proc_start_date)+1;

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';