VIEW: APPS.BEN_PER_INFO_CHG_CS_LER_D

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)