Pay Header Information#

Functionality:#

This function retrieves information as seen on IPPH, given a pay header ID

Parameters:#

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.

Notes#

Click to create a new notes page