View: BENBV_PER_INFO_CHG_CS_LER_V

Product:	BEN - Advanced Benefits
Description:	This view identifies a specific change to a column in a table from which life events can be detected when a person's data changes.
Implementation/DBA Data:	APPS.BENBV_PER_INFO_CHG_CS_LER_V

View Text

SELECT PSL.EFFECTIVE_START_DATE
, PSL.EFFECTIVE_END_DATE
, PSL.SOURCE_COLUMN
, PSL.SOURCE_TABLE
, PSL.NAME
, PSL.WHATIF_LBL_TXT
, PSL.OLD_VAL
, PSL.NEW_VAL
, PSL.PER_INFO_CHG_CS_LER_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_INFO_CHG_CS_LER_F:PSL'
, PSL.RULE_OVERRIDES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PSL.RULE_OVERRIDES_FLAG)
, /* ID COLUMNS */ PSL.PER_INFO_CHG_CS_LER_ID
, PSL.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ PSL.LAST_UPDATE_DATE
, PSL.LAST_UPDATED_BY
, PSL.CREATED_BY
, PSL.CREATION_DATE
FROM BEN_PER_INFO_CHG_CS_LER_F PSL
WHERE PSL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PSL.BUSINESS_GROUP_ID) WITH READ ONLY

Columns