[Home] [Help]
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
Name |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
ORDR_TO_PRCS_NUM |
"_DF:CSR" |
CSS_RLTD_PER_PER_IN_LER_ID |
BUSINESS_GROUP_ID |
LER_ID |
RSLTG_LER_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |