[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
1390: -- separately. The default is that the entry will be created in the
1391: -- payroll period which covers the end of the week of absence for which
1392: -- the entry is created. If, however, that payroll period is in the
1393: -- past, or has already been processed, or is closed, or is after the
1394: -- person's last standard process date, then the entry must be placed
1395: -- in the next open period for which no main payroll run has been
1396: -- performed and which falls around or before the last standard process
1397: -- date. If the entry cannot be created in any such period, for whatever
1398: -- reason, then an error should be raised and the user required to
1392: -- the entry is created. If, however, that payroll period is in the
1393: -- past, or has already been processed, or is closed, or is after the
1394: -- person's last standard process date, then the entry must be placed
1395: -- in the next open period for which no main payroll run has been
1396: -- performed and which falls around or before the last standard process
1397: -- date. If the entry cannot be created in any such period, for whatever
1398: -- reason, then an error should be raised and the user required to
1399: -- resolve the problem before any entry for the absence can be created.
1400: -- The user may choose to pay SMP as a lump sum, in which case all
2093: hr_utility.trace('average earnings * 90 percent greater than lower rate, no need to underpin');
2094: hypothetical_entry.amount (p_week_number)
2095: := least(round(
2096: (average_earnings * g_SMP_element.higher_SMP_rate)
2097: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2098: end if;
2099: else
2100: hr_utility.trace('Due date and week Commencing both after 06-APr-2003, therfore lowest of average earnings and standard rate');
2101: hypothetical_entry.amount (p_week_number)
2096: (average_earnings * g_SMP_element.higher_SMP_rate)
2097: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2098: end if;
2099: else
2100: hr_utility.trace('Due date and week Commencing both after 06-APr-2003, therfore lowest of average earnings and standard rate');
2101: hypothetical_entry.amount (p_week_number)
2102: := least(round(
2103: (average_earnings * g_SMP_element.higher_SMP_rate)
2104: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2100: hr_utility.trace('Due date and week Commencing both after 06-APr-2003, therfore lowest of average earnings and standard rate');
2101: hypothetical_entry.amount (p_week_number)
2102: := least(round(
2103: (average_earnings * g_SMP_element.higher_SMP_rate)
2104: + 0.0049,2), g_SMP_element.standard_SMP_rate);
2105: end if;
2106: end if;
2107: --
2108: hypothetical_entry.recoverable_amount (p_week_number)