Payment Rules Information#
Functionality:#
This function retrieves information as seen on IPPM, for an employee's payment rules.Parameters:#
EEM_ID | The actual ID for the employment record of the employee you are getting data for |
WHAT | Identifies which element of the IPPM display you want to access. This must be one of the values noted below. |
SPLIT_SEQUENCE | Optional. Identifies which split sequence you want to access. This must be one of the values noted below. |
AS_OF | Optional. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used. |
WHAT Parameter Values#
- Any field name from P2K_PR_PAYMENT_RULE_DETAILS
SPLIT_SEQUENCE Parameter Values - OPTIONAL#
FIRST | Default if not provided. The first split sequence in ascending order (regardless of split sequence code). |
LAST | The last split sequence in ascending order |
PAY REMAIN | The one split sequence record with the PAY_REMAINING toggle on |
a number from 1 to 999 | This reflects an ordinal number (1 is first, 2 is second, etc. rather than looking for an exact match for sequence number) |
Returns: #
Varchar2 (regardless of the type of data being requested)Errors: #
- If an invalid WHAT parameter is passed, then BAD WHAT is returned
- If bad data, or no data is found then ERROR is returned
Example: #
P2K_PU.PPR(~,'BANK_TRANSIT_CODE','PAY REMAIN')
- Will return the BANK_TRANSIT_CODE for the payment rules record that is marked with the PAY_REMAINING toggle on.
Notes:#
PAY_REMAINING | The value returned will either be 1 (if the toggle is on) or N if the toggle is off. The data in the database is "1" or NULL |