DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on FFFUNC

Line 1008: -- fffunc

1004: -- OUT: p_pre01jul1983_ratio - ratio to use when calculating the pre 01 July 1983 portion of ETP
1005: -- p_post30jun1983_ratio - ratio to use when calculating the post 30 June 1983 portion of ETP
1006: --
1007: -- USES: hr_utility
1008: -- fffunc
1009: -- hr_au_holidays
1010: --
1011: function etp_prepost_ratios
1012: (p_assignment_id in number

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

1178: END IF;
1179: p_pre01jul1983_days := 0;
1180: p_pre01jul1983_ratio := 0;
1181: p_post30jun1983_ratio := 1;
1182: l_days_worked_post := fffunc.days_between(p_termination_date, l_calculation_date);
1183: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1184: p_post30jun1983_days := l_days_worked_post - l_days_suspended_post;
1185: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1186: /* Bug 4177679 Only if the calculation date is entered then the p_le_etp_service_date will be passed*/

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

1198: END IF;
1199: p_post30jun1983_days := 0;
1200: p_post30jun1983_ratio := 0;
1201: p_pre01jul1983_ratio := 1;
1202: l_days_worked_pre := fffunc.days_between(p_termination_date, l_calculation_date);
1203: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1204: p_pre01jul1983_days := l_days_worked_pre - l_days_suspended_pre;
1205: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1206: /* Bug 4177679 Only if the calculation date is entered then the p_le_etp_service_date will be passed*/

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

1214: END IF;
1215: --
1216: -- Calculate the number of days worked for pre, post and total
1217: --
1218: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);
1219: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);
1220: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1221: --
1222: -- How many of these days were suspended without pay for pre, post and total

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

1215: --
1216: -- Calculate the number of days worked for pre, post and total
1217: --
1218: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);
1219: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);
1220: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1221: --
1222: -- How many of these days were suspended without pay for pre, post and total
1223: --

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

1216: -- Calculate the number of days worked for pre, post and total
1217: --
1218: l_days_worked_pre := fffunc.days_between(l_pre_date, l_calculation_date);
1219: l_days_worked_post := fffunc.days_between(p_termination_date, l_post_date);
1220: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1221: --
1222: -- How many of these days were suspended without pay for pre, post and total
1223: --
1224: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, l_pre_date);