View: BENBV_CSS_RLTD_PER_PER_IN_LE_V

Product:	BEN - Advanced Benefits
Description:	This view identifies which life event reported by or detected for a participant may spawn a life event for other persons related to him or her.
Implementation/DBA Data:	APPS.BENBV_CSS_RLTD_PER_PER_IN_LE_V

View Text

SELECT CSR.EFFECTIVE_START_DATE
, CSR.EFFECTIVE_END_DATE
, CSR.ORDR_TO_PRCS_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CSS_RLTD_PER_PER_IN_LER_F:CSR'
, /* ID COLUMNS */ CSR.CSS_RLTD_PER_PER_IN_LER_ID
, CSR.BUSINESS_GROUP_ID
, CSR.LER_ID
, CSR.RSLTG_LER_ID
, /* WHO COLUMNS */ CSR.LAST_UPDATE_DATE
, CSR.LAST_UPDATED_BY
, CSR.CREATED_BY
, CSR.CREATION_DATE
FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR
WHERE CSR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CSR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns