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#
| START_DATE | END_DATE | TIMES_REMAINING | TIME_ENTERED | TIME_BASIS |
| DISTRIBUTION_MASK | REFERENCE_INFO | WORK_ORDER |
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
