Element Information #
Functionality: #
This function retrieves a comma seperated list of pay components (enclosed within single quotes) 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 elementErrors: #
- *BAD ELEMENT When there is no element defined with that code name
Example: #
P2K_PU.ELEMENT_PC('W2-SCHL-TAX')
- Will return a comma seperated list of pay component codes (e.g. "'6802','6852','6911'")
