[Home] [Help]
View: BEN_ACTY_RT_DED_SCHED_D
View Text
SELECT ADS.ROWID ROW_ID
, ADS.ACTY_RT_DED_SCHED_ID
, ADS.EFFECTIVE_START_DATE
, ADS.EFFECTIVE_END_DATE
, ACTY_BASE_RT.NAME
, DED_SCHED2.FORMULA_NAME
, DED_SCHED.MEANING
, ADS.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ACTY_RT_DED_SCHED_F ADS
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, HR_LOOKUPS DED_SCHED
, FF_FORMULAS_F DED_SCHED2
WHERE FUSER.USER_ID (+)= ADS .LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= ADS .ACTY_BASE_RT_ID
AND DED_SCHED.LOOKUP_CODE (+)= ADS .DED_SCHED_CD
AND DED_SCHED.LOOKUP_TYPE (+)= 'BEN_DED_SCHED'
AND DED_SCHED2.FORMULA_ID (+)= ADS .DED_SCHED_RL
AND ADS.EFFECTIVE_START_DATE BETWEEN DED_SCHED2.EFFECTIVE_START_DATE
AND DED_SCHED2.EFFECTIVE_END_DATE
Columns
Name |
ROW_ID |
ACTY_RT_DED_SCHED_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
ACTY_BASE_RT_NAME |
DED_SCHED_NAME |
DED_SCHED_MEANING |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |