eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BEN_ACTY_RT_DED_SCHED_D

Source

View Text - Preformatted


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

View Text - HTML Formatted

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