View: BENBV_LER_PER_INFO_CS_LER_V

Product:	BEN - Advanced Benefits
Description:	This view associates a life event reason to the discrete data changes which indicate how to detect the life event for a person.
Implementation/DBA Data:	APPS.BENBV_LER_PER_INFO_CS_LER_V

View Text

SELECT LPL.EFFECTIVE_START_DATE
, LPL.EFFECTIVE_END_DATE
, LPL.LER_PER_INFO_CS_LER_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_LER_PER_INFO_CS_LER_F:LPL'
, /* CODES */ LPL.CHG_MANDATORY_CD
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LPL.CHG_MANDATORY_CD)
, /* ID COLUMNS */ LPL.LER_PER_INFO_CS_LER_ID
, LPL.BUSINESS_GROUP_ID
, LPL.LER_ID
, LPL.PER_INFO_CHG_CS_LER_ID
, /* WHO COLUMNS */ LPL.LAST_UPDATE_DATE
, LPL.LAST_UPDATED_BY
, LPL.CREATED_BY
, LPL.CREATION_DATE
FROM BEN_LER_PER_INFO_CS_LER_F LPL
WHERE LPL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, LPL.BUSINESS_GROUP_ID) WITH READ ONLY

Columns