[Home] [Help]
30: were being read by get_entry_details and
31: raising a no_data_found error.
32: Added a few check_parameter procedures.
33: 9 Nov 95 N Simpson Removed some obsolete code.
34: 16 Nov 95 N Simpson Changed last_standard_process_date
35: to final_process_date throughout as
36: it should have been in the first place.
37: 27 Nov 95 N Simpson Converted the SMP rate set for each
38: entry to use the lookup meaning instead
1326: -- separately. The default is that the entry will be created in the
1327: -- payroll period which covers the end of the week of absence for which
1328: -- the entry is created. If, however, that payroll period is in the
1329: -- past, or has already been processed, or is closed, or is after the
1330: -- person's last standard process date, then the entry must be placed
1331: -- in the next open period for which no main payroll run has been
1332: -- performed and which falls around or before the last standard process
1333: -- date. If the entry cannot be created in any such period, for whatever
1334: -- reason, then an error should be raised and the user required to
1328: -- the entry is created. If, however, that payroll period is in the
1329: -- past, or has already been processed, or is closed, or is after the
1330: -- person's last standard process date, then the entry must be placed
1331: -- in the next open period for which no main payroll run has been
1332: -- performed and which falls around or before the last standard process
1333: -- date. If the entry cannot be created in any such period, for whatever
1334: -- reason, then an error should be raised and the user required to
1335: -- resolve the problem before any entry for the absence can be created.
1336: -- The user may choose to pay SMP as a lump sum, in which case all
2014: hr_utility.trace('average earnings * 90 percent greater than lower rate, no need to underpin');
2015: hypothetical_entry.amount (p_week_number)
2016: := least(round(
2017: (average_earnings * g_SMP_element.higher_SMP_rate)
2018: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2019: end if;
2020: else
2021: hr_utility.trace('Due date and week Commencing both after 06-APr-2003, therfore lowest of average earnings and standard rate');
2022: hypothetical_entry.amount (p_week_number)
2017: (average_earnings * g_SMP_element.higher_SMP_rate)
2018: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2019: end if;
2020: else
2021: hr_utility.trace('Due date and week Commencing both after 06-APr-2003, therfore lowest of average earnings and standard rate');
2022: hypothetical_entry.amount (p_week_number)
2023: := least(round(
2024: (average_earnings * g_SMP_element.higher_SMP_rate)
2025: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2021: hr_utility.trace('Due date and week Commencing both after 06-APr-2003, therfore lowest of average earnings and standard rate');
2022: hypothetical_entry.amount (p_week_number)
2023: := least(round(
2024: (average_earnings * g_SMP_element.higher_SMP_rate)
2025: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2026: end if;
2027: end if;
2028: --
2029: hypothetical_entry.recoverable_amount (p_week_number)