DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on FFFUNC

Line 912: -- fffunc

908: -- OUT: p_pre01jul1983_ratio - ratio to use when calculating the pre 01 July 1983 portion of ETP
909: -- p_post30jun1983_ratio - ratio to use when calculating the post 30 June 1983 portion of ETP
910: --
911: -- USES: hr_utility
912: -- fffunc
913: -- hr_au_holidays
914: --
915: function etp_prepost_ratios
916: (p_assignment_id in number

Line 1086: l_days_worked_post := fffunc.days_between(p_termination_date, l_calculation_date);

1082: END IF;
1083: p_pre01jul1983_days := 0;
1084: p_pre01jul1983_ratio := 0;
1085: p_post30jun1983_ratio := 1;
1086: l_days_worked_post := fffunc.days_between(p_termination_date, l_calculation_date);
1087: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1088: p_post30jun1983_days := l_days_worked_post - l_days_suspended_post;
1089: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1090: /* Bug 4177679 Only if the calculation date is entered then the p_le_etp_service_date will be passed*/

Line 1106: l_days_worked_pre := fffunc.days_between(p_termination_date, l_calculation_date);

1102: END IF;
1103: p_post30jun1983_days := 0;
1104: p_post30jun1983_ratio := 0;
1105: p_pre01jul1983_ratio := 1;
1106: l_days_worked_pre := fffunc.days_between(p_termination_date, l_calculation_date);
1107: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1108: p_pre01jul1983_days := l_days_worked_pre - l_days_suspended_pre;
1109: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1110: /* Bug 4177679 Only if the calculation date is entered then the p_le_etp_service_date will be passed*/

Line 1122: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);

1118: END IF;
1119: --
1120: -- Calculate the number of days worked for pre, post and total
1121: --
1122: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);
1123: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);
1124: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1125: --
1126: -- How many of these days were suspended without pay for pre, post and total

Line 1123: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);

1119: --
1120: -- Calculate the number of days worked for pre, post and total
1121: --
1122: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);
1123: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);
1124: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1125: --
1126: -- How many of these days were suspended without pay for pre, post and total
1127: --

Line 1124: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;

1120: -- Calculate the number of days worked for pre, post and total
1121: --
1122: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);
1123: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);
1124: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1125: --
1126: -- How many of these days were suspended without pay for pre, post and total
1127: --
1128: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, l_pre_date);