Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_RLTD_PER_CHG_CS_LER_D |
SELECT RCL.ROWID ROW_ID
, RCL.RLTD_PER_CHG_CS_LER_ID
, RCL.EFFECTIVE_START_DATE
, RCL.EFFECTIVE_END_DATE
, RCL.NAME
, RCL.WHATIF_LBL_TXT
, RCL.OLD_VAL
, RCL.NEW_VAL
, RCL.SOURCE_COLUMN
, RCL.SOURCE_TABLE
, FF1.FORMULA_NAME
, RCL.LAST_UPDATE_DATE
, FUSER.USER_NAME
, RCL.RULE_OVERRIDES_FLAG
FROM BEN_RLTD_PER_CHG_CS_LER_F RCL
, FND_USER_VIEW FUSER
, FF_FORMULAS_F FF1
WHERE FUSER.USER_ID (+)= RCL.LAST_UPDATED_BY
AND FF1.FORMULA_ID (+)= RCL.RLTD_PER_CHG_CS_LER_RL
AND RCL.EFFECTIVE_START_DATE BETWEEN FF1.EFFECTIVE_START_DATE(+)
AND FF1.EFFECTIVE_END_DATE(+)