You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need table and column name to get beneficiary enrollment information to use at ben_fn_get_char_value

edited Sep 5, 2020 12:10AM in Benefits 1 comment

Summary

Need table and column name to get beneficiary enrollment information to use at ben_fn_get_char_value function

Content

In FF type Beneficiary Certification Required, I need format to get beneficiary enrollment information to use ben_fn_get_char_value function

For Ex: For dependent enrollment information we can use below

l_curr_dep_life_plan_enrolled = ben_fn_get_char_value('BEN_ELIG_CVRD_DPNT','ENROLLED',l_pl_name ,'null' ,'DEPENDENT_FULL_NAME' ,l_contact_full_name)

But I need to fetch same information for beneficiary. Can you please provide me required info to get to know whether beneficiary is enrolled or not in plan

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!