Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies changes or life events that occur for a contact, usually for the purposes of changing the contact's eligibility or opportunity to enroll in benefits. |
Implementation/DBA Data: | APPS.BENBV_RLTD_PER_CHG_CS_LER_V |
SELECT RCL.EFFECTIVE_START_DATE
, RCL.EFFECTIVE_END_DATE
, RCL.SOURCE_COLUMN
, RCL.SOURCE_TABLE
, RCL.NAME
, RCL.WHATIF_LBL_TXT
, RCL.OLD_VAL
, RCL.NEW_VAL
, RCL.RLTD_PER_CHG_CS_LER_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_RLTD_PER_CHG_CS_LER_F:RCL'
, RCL.RULE_OVERRIDES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, RCL.RULE_OVERRIDES_FLAG)
, /* ID COLUMNS */ RCL.RLTD_PER_CHG_CS_LER_ID
, RCL.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ RCL.LAST_UPDATE_DATE
, RCL.LAST_UPDATED_BY
, RCL.CREATED_BY
, RCL.CREATION_DATE
FROM BEN_RLTD_PER_CHG_CS_LER_F RCL
WHERE RCL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, RCL.BUSINESS_GROUP_ID) WITH READ ONLY