View: BENBV_ENRT_PREM_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the premium values calculated for a person for a plan or option in plan.
Implementation/DBA Data:	APPS.BENBV_ENRT_PREM_V

View Text

SELECT EPR.PROGRAM_UPDATE_DATE
, EPR.VAL
, EPR.UOM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_PREM_F:EPR'
, /* ID COLUMNS */ EPR.ENRT_PREM_ID
, EPR.ACTL_PREM_ID
, EPR.BUSINESS_GROUP_ID
, EPR.REQUEST_ID
, EPR.PROGRAM_APPLICATION_ID
, EPR.PROGRAM_ID
, EPR.ELIG_PER_ELCTBL_CHC_ID
, EPR.ENRT_BNFT_ID
, /* WHO COLUMNS */ EPR.LAST_UPDATE_DATE
, EPR.LAST_UPDATED_BY
, EPR.CREATED_BY
, EPR.CREATION_DATE
FROM BEN_ENRT_PREM EPR
WHERE EPR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EPR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns