P 2 K_PU.ELEMENT_PC
Back to current versionRestore this version

Element Information#

Functionality:#

This function retrieves a comma seperated list of pay components as seen on IPEL.

Parameters:#

ELEMENT_CODE The element code you are examining
BASIC_ONLY optional If any value other than "N" is specified here, then only the basic pay copmonents on that element are provided. Otherwise (default) the basic and compound elements are included.

Returns: #

Varchar2 or NULL if there are no pay components defined in that element

Errors: #

Example: #

P2K_PU.ELEMENT_PC('W2-SCHL-TAX')

Will return a comma seperated list of pay component codes (e.g. "6802, 6852, 6911")

Notes#

Click to create a new notes page