Benefit Lines Information#
Functionality:#
This function retrieves information computed during the payroll and stored in the P2K_BE_BENEFIT_LINES and P2K_BE_BENEFIT_LINE_DETAILS tablesParameters:#
PPH_ID | The actual ID for the employment record of the employee you are getting data for |
PLAN_CODE | The plan code you are retrieving information for |
WHAT | Identifies which element of the field you want to access. This must be one of the values as noted below. |
WHAT Parameter Values#
- Any field name from P2K_BE_BENEFIT_LINES
- BC-Bnnnn - This will return the AMOUNT or AMOUNT_OVERRIDE for the component value where nnnn is the benefit component code
Returns: #
Varchar2 (regardless of the type of data being requested)Errors: #
- If an invalid PLAN_CODE parameter is passed, then ** BAD PLAN CODE is returned
- If a bad benefit component code is provided, then ** BAD BC CODE is returned
- If an invalid WHAT parameter is provided, then ** BAD WHAT is returned.
NULL is return under any of these conditions:
- If the Plan is not found on the pay header
- The benefit component code is not found on the pay line related to the plan
Example: #
P2K_PU.BBL(~,'VISION','COVERAGE_STEP_CODE')
Will return the COVERAGE_STEP_CODE processed on this pay for the VISION plan.
P2K_PU.BBL(~,'LIFE-GW','BC-B0680')
Will return the deduction amount BC-B0680 for the employee's LIFE-GW plan