P2K_PPAMTS.SPELPAY#
Functionality#
This database function will return the value of the pay components included in the identified element for the specified pay header.Parameters:#
PPH_ID | The ID for the pay header record |
PEL_ID | The ID for the element (see P2K_SPGETPEL) |
Returns:#
NumericErrors:#
If an invalid parameter is passed, then zero is returnedIf there is no value or record for that lexicon and value pair, then NULL is returned
Example:#
P2K_PPAMTS.SPELPAY(PPH_ID,P2K_PPAMTS.SPGETPEL('TOTAL_EARNS')) will get the ID of the element TOTAL_EARNS (in the reference to P2K_PPAMTS.SPGETPEL) for the Pay Header identified by the PPH_ID.