P2K_PPAMTS.SPPCPAY#

Functionality#

This database function will return the value of the pay component identified for the specified pay header.

Parameters:#

PPH_ID	The ID for the pay header record
PPC_ID	The ID for the pay component(see P2K_PPAMTS.SPGETPPC)

Returns:#

Numeric

Errors:#

If an invalid parameter is passed, then zero is returned

If there is no value or record for that pay header and pay component pair, then NULL is returned

Example:#

P2K_PPAMTS.SPPCPAY(PPH_ID,P2K_PPAMTS.SPGETPPC('3200')) will get the ID of the pay component 3200 (in the reference to P2K_PPAMTS.SPGETPPC) for the Pay Header identified by the PPH_ID.

Operation#

Note that the pay header does not have to be closed or in any status at all other than having been calculated at least once (even in a trial payrun).

---

Notes #

Click to create a new notes page