Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the person or organization designated by a participant in a plan as the beneficiary of plan benefits. |
Implementation/DBA Data: | APPS.BENBV_PL_BNF_V |
SELECT PBN.EFFECTIVE_START_DATE
, PBN.EFFECTIVE_END_DATE
, PBN.PROGRAM_UPDATE_DATE
, PBN.PCT_DSGD_NUM
, PBN.AMT_DSGD_VAL
, PBN.AMT_DSGD_UOM
, PBN.ADDL_INSTRN_TXT
, PBN.DSGN_THRU_DT
, PBN.DSGN_STRT_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_BNF_F:PBN'
, /* CODES */ PBN.PRMRY_CNTNGNT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRMRY_CNTNGNT'
, PBN.PRMRY_CNTNGNT_CD)
, /* ID COLUMNS */ PBN.PL_BNF_ID
, PBN.BUSINESS_GROUP_ID
, PBN.PRTT_ENRT_RSLT_ID
, PBN.PER_IN_LER_ID
, PBN.REQUEST_ID
, PBN.PROGRAM_APPLICATION_ID
, PBN.PROGRAM_ID
, PBN.ORGANIZATION_ID
, PBN.BNF_PERSON_ID
, PBN.TTEE_PERSON_ID
, /* WHO COLUMNS */ PBN.LAST_UPDATE_DATE
, PBN.LAST_UPDATED_BY
, PBN.CREATED_BY
, PBN.CREATION_DATE
FROM BEN_PL_BNF_F PBN
WHERE PBN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBN.BUSINESS_GROUP_ID) WITH READ ONLY