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 element

Errors: #

  • *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')
This can be used in reporting with a where clause that looks as such:
instr(p2k_pu.element_pc(''element_code''),'''40''')>0

----

Notes #

Click to create a new notes page