DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on FFFUNC

Line 610: l_total_days := fffunc.days_between(l_proc_end_date , l_proc_start_date)+1;

606: hr_utility.trace('prorate_wac : '||prorate_wac);
607: hr_utility.trace('prorate_date : '||prorate_date);
608:
609: if (p_date_earned <> start_date ) then
610: l_total_days := fffunc.days_between(l_proc_end_date , l_proc_start_date)+1;
611: -------------------------------------------------------------------------------------------------
612: --Bug# 4149190
613: --p_pay_proc_start_date, p_pay_proc_end_date are replaced by l_proc_start_date,
614: --l_proc_end_date respectively.

Line 646: l_days := fffunc.days_between(prorate_date,start_date);

642:
643: if ((start_wac = 'PR' or start_wac = 'SG') and (prorate_wac = 'EP' or prorate_wac = 'WP' or start_wac = 'SP'))then
644: /* Need to calculate the proration for the first period, since the wac in the second period is
645: not eligible for CPF*/
646: l_days := fffunc.days_between(prorate_date,start_date);
647: p_cpf_calc_type := start_wac;
648: l_prorator := l_days / l_total_days;
649: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);
650: hr_utility.trace('l_days : '||l_days );

Line 655: l_days := fffunc.days_between(l_proc_end_date,prorate_date)+1;

651:
652: elsif ((start_wac = 'WP' or start_wac = 'EP' or start_wac = 'SP') and (prorate_wac = 'PR' or prorate_wac = 'SG')) then
653: /* Need to calculate the proration for the second period and first period does not have
654: eligible for the CPF Proration */
655: l_days := fffunc.days_between(l_proc_end_date,prorate_date)+1;
656: /* Added +1 to include prorate date also */
657: hr_utility.trace('l_days : '||l_days );
658: p_cpf_calc_type := prorate_wac;
659: l_prorator := l_days / l_total_days;

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

661: elsif ((start_wac = 'SG' or start_wac = 'PR') and (prorate_wac = 'SG' or prorate_wac = 'PR')) then
662: /* Need not calculate the CPF Calculation. Hence setting the l_prorator value to 1 and the
663: CPF Calcualtion type to prorate type */
664: if (l_emp_start_bet_period = 'Y' and l_emp_end_bet_period = 'Y' ) then
665: l_days := fffunc.days_between(l_proc_end_date, l_proc_start_date)+1;
666: l_prorator := l_days/l_total_days;
667:
668: elsIf (l_emp_start_bet_period = 'Y') then
669: l_days := fffunc.days_between(p_pay_proc_end_date, l_proc_start_date)+1;

Line 669: l_days := fffunc.days_between(p_pay_proc_end_date, l_proc_start_date)+1;

665: l_days := fffunc.days_between(l_proc_end_date, l_proc_start_date)+1;
666: l_prorator := l_days/l_total_days;
667:
668: elsIf (l_emp_start_bet_period = 'Y') then
669: l_days := fffunc.days_between(p_pay_proc_end_date, l_proc_start_date)+1;
670: l_prorator := l_days/l_total_days;
671:
672: elsif (l_emp_end_bet_period = 'Y') then
673: l_days := fffunc.days_between(l_proc_end_date,p_pay_proc_start_date)+1;

Line 673: l_days := fffunc.days_between(l_proc_end_date,p_pay_proc_start_date)+1;

669: l_days := fffunc.days_between(p_pay_proc_end_date, l_proc_start_date)+1;
670: l_prorator := l_days/l_total_days;
671:
672: elsif (l_emp_end_bet_period = 'Y') then
673: l_days := fffunc.days_between(l_proc_end_date,p_pay_proc_start_date)+1;
674: l_prorator := l_days/l_total_days;
675:
676: else
677: l_prorator := 1.0;