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