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 from P2K_PR_SUNDRY_LINES
• PAYEE_NAME - This will return the FIRST_NAME and LAST_NAME of the Payee linked to the PSL record
• PAYEE_CODE - This 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: #

• *BAD EEM_ID When there is no employment record with the ID provided
• *BAD PC CODE When there is no such pay component
• *BAD WHAT When the WHAT parameter is not one of the values supported
• *BAD SUNDRY When more than one sundry line meets the criteria.

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