eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_SI_PKG dependencies on FFFUNC

Line 1219: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;

1215: IF l_period_type = 'Lunar Month' THEN
1216: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_4WEEKLY'));
1217: END IF;
1218: IF l_asg_start_date > l_period_start_date THEN
1219: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1220: IF l_Asg_End_Date < l_period_end_date THEN
1221: Work_Days := fffunc.days_between(l_asg_end_date, l_asg_start_date) + 1;
1222: ELSE
1223: Work_Days := fffunc.days_between(l_period_end_date, l_asg_start_date) + 1;

Line 1221: Work_Days := fffunc.days_between(l_asg_end_date, l_asg_start_date) + 1;

1217: END IF;
1218: IF l_asg_start_date > l_period_start_date THEN
1219: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1220: IF l_Asg_End_Date < l_period_end_date THEN
1221: Work_Days := fffunc.days_between(l_asg_end_date, l_asg_start_date) + 1;
1222: ELSE
1223: Work_Days := fffunc.days_between(l_period_end_date, l_asg_start_date) + 1;
1224: END If;
1225: Average_SI_Days := round((Average_SI_Days / Total_Days * Work_Days),2);

Line 1223: Work_Days := fffunc.days_between(l_period_end_date, l_asg_start_date) + 1;

1219: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1220: IF l_Asg_End_Date < l_period_end_date THEN
1221: Work_Days := fffunc.days_between(l_asg_end_date, l_asg_start_date) + 1;
1222: ELSE
1223: Work_Days := fffunc.days_between(l_period_end_date, l_asg_start_date) + 1;
1224: END If;
1225: Average_SI_Days := round((Average_SI_Days / Total_Days * Work_Days),2);
1226:
1227: ELSE

Line 1229: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;

1225: Average_SI_Days := round((Average_SI_Days / Total_Days * Work_Days),2);
1226:
1227: ELSE
1228: IF l_asg_end_date < l_period_end_date THEN
1229: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1230: Work_Days := fffunc.days_between(l_asg_end_date, l_period_start_date) + 1;
1231: Average_SI_Days := round((Average_SI_Days / Total_Days * Work_Days),2);
1232: END IF;
1233: END IF;

Line 1230: Work_Days := fffunc.days_between(l_asg_end_date, l_period_start_date) + 1;

1226:
1227: ELSE
1228: IF l_asg_end_date < l_period_end_date THEN
1229: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1230: Work_Days := fffunc.days_between(l_asg_end_date, l_period_start_date) + 1;
1231: Average_SI_Days := round((Average_SI_Days / Total_Days * Work_Days),2);
1232: END IF;
1233: END IF;
1234:

Line 1463: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;

1459: /* Added Proration code for Bug 3412227
1460: Pro-rate SI base and threshold if employee started or left during the payroll period */
1461: IF l_Asg_Start_Date > l_period_start_date THEN
1462:
1463: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1464: IF l_Asg_End_Date < l_period_end_date THEN
1465: Work_Days := fffunc.days_between(l_Asg_End_Date, l_Asg_Start_Date) + 1;
1466: ELSE
1467: Work_Days := fffunc.days_between(l_period_end_date, l_Asg_Start_Date) + 1;

Line 1465: Work_Days := fffunc.days_between(l_Asg_End_Date, l_Asg_Start_Date) + 1;

1461: IF l_Asg_Start_Date > l_period_start_date THEN
1462:
1463: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1464: IF l_Asg_End_Date < l_period_end_date THEN
1465: Work_Days := fffunc.days_between(l_Asg_End_Date, l_Asg_Start_Date) + 1;
1466: ELSE
1467: Work_Days := fffunc.days_between(l_period_end_date, l_Asg_Start_Date) + 1;
1468: END IF;
1469: Threshold_or_Max_SI := round((Threshold_or_Max_SI / Total_Days * Work_Days),2);

Line 1467: Work_Days := fffunc.days_between(l_period_end_date, l_Asg_Start_Date) + 1;

1463: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1464: IF l_Asg_End_Date < l_period_end_date THEN
1465: Work_Days := fffunc.days_between(l_Asg_End_Date, l_Asg_Start_Date) + 1;
1466: ELSE
1467: Work_Days := fffunc.days_between(l_period_end_date, l_Asg_Start_Date) + 1;
1468: END IF;
1469: Threshold_or_Max_SI := round((Threshold_or_Max_SI / Total_Days * Work_Days),2);
1470:
1471: ELSE

Line 1475: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;

1471: ELSE
1472:
1473: IF l_Asg_End_Date < l_period_end_date THEN
1474:
1475: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1476: Work_Days := fffunc.days_between(l_Asg_End_Date, l_period_start_date) + 1;
1477: Threshold_or_Max_SI := round((Threshold_or_Max_SI / Total_Days * Work_Days),2) ;
1478:
1479: END IF;

Line 1476: Work_Days := fffunc.days_between(l_Asg_End_Date, l_period_start_date) + 1;

1472:
1473: IF l_Asg_End_Date < l_period_end_date THEN
1474:
1475: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1476: Work_Days := fffunc.days_between(l_Asg_End_Date, l_period_start_date) + 1;
1477: Threshold_or_Max_SI := round((Threshold_or_Max_SI / Total_Days * Work_Days),2) ;
1478:
1479: END IF;
1480: END IF;