View: BENBV_PL_R_OIPL_PREM_BY_MO_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the premium values calculated by the premium calculation process.
Implementation/DBA Data:	APPS.BENBV_PL_R_OIPL_PREM_BY_MO_V

View Text

SELECT PBM.EFFECTIVE_START_DATE
, PBM.EFFECTIVE_END_DATE
, PBM.PROGRAM_UPDATE_DATE
, PBM.MO_NUM
, PBM.YR_NUM
, PBM.VAL
, PBM.UOM
, PBM.PRTTS_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_R_OIPL_PREM_BY_MO_F:PBM'
, PBM.MNL_ADJ_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PBM.MNL_ADJ_FLAG)
, /* ID COLUMNS */ PBM.PL_R_OIPL_PREM_BY_MO_ID
, PBM.ACTL_PREM_ID
, PBM.BUSINESS_GROUP_ID
, PBM.COST_ALLOCATION_KEYFLEX_ID
, PBM.REQUEST_ID
, PBM.PROGRAM_ID
, PBM.PROGRAM_APPLICATION_ID
, /* WHO COLUMNS */ PBM.LAST_UPDATE_DATE
, PBM.LAST_UPDATED_BY
, PBM.CREATED_BY
, PBM.CREATION_DATE
FROM BEN_PL_R_OIPL_PREM_BY_MO_F PBM
WHERE PBM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBM.BUSINESS_GROUP_ID) WITH READ ONLY

Columns