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#

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