View: BENBV_YR_PERD_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the start and end dates for a plan year which may apply to multiple plans and/or programs.
Implementation/DBA Data:	APPS.BENBV_YR_PERD_V

View Text

SELECT YRP.END_DATE
, YRP.START_DATE
, YRP.LMTN_YR_STRT_DT
, YRP.LMTN_YR_END_DT
, YRP.PERDS_IN_YR_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_YR_PERD:YRP'
, /* CODES */ YRP.PERD_TM_UOM_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, YRP.PERD_TM_UOM_CD)
, YRP.PERD_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PERD_TYP'
, YRP.PERD_TYP_CD)
, /* ID COLUMNS */ YRP.YR_PERD_ID
, YRP.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ YRP.LAST_UPDATE_DATE
, YRP.LAST_UPDATED_BY
, YRP.CREATED_BY
, YRP.CREATION_DATE
FROM BEN_YR_PERD YRP
WHERE YRP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, YRP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns