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 tables

Parameters:#

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

---

Notes#

Click to create a new notes page