P2K_PPGEN.SPINELEM#

Functionality#

This database function will return the ID of the Pay Component, if it is in the element identified. If it is not, it will return NULL

Parameters:#

PPC_ID	The ID for the pay component
PEL_ID	The ID for the element

Returns:#

Numeric

Errors:#

If an invalid parameter is passed, then null is returned

Example:#

P2K_PPGEN.SPINELEM(P2K_PPAMTS.SPGETPPC('1240'), P2K_PPAMTS.SPGETPEL('GROSS'))

This example will give you the ID of the pay component 1240(i.e. the value returned of P2K_PPAMTS.SPGETPPC) if that pay component is defined in the GROSS element.

---

Notes #

Click to create a new notes page