!!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-B''nnnn''__}} - 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|Edit:Internal.P2K_PU.BBL] [{InsertPage page='Internal.P2K_PU.BBL' default='Click to create a new notes page'}]