View: BENBV_POPL_YR_PERD_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the years for which this plan or program is active. The actual plan years, with start and stop dates, are associated to the plan or program.
Implementation/DBA Data:	APPS.BENBV_POPL_YR_PERD_V

View Text

SELECT CPY.ORDR_NUM
, CPY.ACPT_CLM_RQSTS_THRU_DT
, CPY.PY_CLMS_THRU_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_POPL_YR_PERD:CPY'
, /* ID COLUMNS */ CPY.POPL_YR_PERD_ID
, CPY.YR_PERD_ID
, CPY.BUSINESS_GROUP_ID
, CPY.PGM_ID
, CPY.PL_ID
, /* WHO COLUMNS */ CPY.LAST_UPDATE_DATE
, CPY.LAST_UPDATED_BY
, CPY.CREATED_BY
, CPY.CREATION_DATE
FROM BEN_POPL_YR_PERD CPY
WHERE CPY.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CPY.BUSINESS_GROUP_ID) WITH READ ONLY

Columns