Pay Header Information#
Functionality:#
This function retrieves information as seen on IPPH, given a pay header IDParameters:#
PPH_ID | The actual ID for the pay header you are getting data for |
WHAT | Identifies which element of the pay header you wish to retrieve |
WHAT Parameter Values#
- Any field name from P2K_PR_PAY_HEADERS
- PRIOR-SAME CATEGORY - This will return the ID of the first pay header for this employee, prior to the pay header identified, that is of the same pay category. If no pay header is found, NULL will be returned.
- PRIOR-nnnnnnn - This will return return the ID of the first pay header for this employee, prior to the pay header identified, that is of the pay category identified by nnnnnnn
- LAST-PCnnnn - This will return return the ID of the first pay header for this employee, prior to the pay header identified, that contains a value for the pay component identified by nnnn
Returns: #
Varchar2 (regardless of the type of data being requested)Errors: #
- *BAD PPH_ID When there is no employment record with the ID provided
- *BAD PAY CATEGORY When there is no such pay category as that entered after PRIOR- in the WHAT parameter
- *BAD WHAT When the WHAT parameter is not one of the values supported
Example: #
P2K_PU.PPH(~,'PRIOR-REG PAY') - Using Pay header ID as the first parameter (~)
- Will return the ID for the first pay in category REG PAY for that employee, prior to Pay Header identified by the ID
P2K_PU.PPH(~,'LAST-PC910') - Using Pay header ID as the first parameter (~)
- Will return the ID for the first pay prior to the Pay Header identified by the ID that has PC 910 in the Pay Amounts tab.