P 2 K_PU.PSN
Back to current versionRestore this version

Sundry Line Information#

Functionality:#

This function retrieves information as seen on IPSN, for an employee's sundry transaction. This function does not retrieve sundry line detail information, only P2K_PR_SUNDRY_LINES.

Parameters:#

EEM_ID The actual ID for the employment record belonging to the employee you are getting data for
PC_CODE The pay component code for the sundry line
WHAT Identifies which element of the sundry line you wish to retrieve
AS_OF Optional. Provides a date to narrow down the sundry line retrieval. If not provided, then the current date will be used.

WHAT Parameter Values#

Any field name on P2K_PR_SUNDRY_LINES
PAYEE_NAMEThis will return the FIRST_NAME and LAST_NAME of the Payee linked to the PSL record
PAYEE_CODEThis will return the PERSON_CODE of the Payee linked to the PSL record

Returns: #

Varchar2 (regardless of the type of data being requested)

If no sundry is found, then NULL is returned

Errors: #

Example: #

P2K_PU.PSN(~,'5030','WORK_ORDER') - Using Employment ID as the first parameter (~)

Will return the WORK_ORDER for the employee's sundry transaction for pay component 5030

Notes#

Click to create a new notes page