VIEW: APPS.BEN_ACTY_RT_DED_SCHED_X

Source

View Text - Preformatted

SELECT ADS.ACTY_RT_DED_SCHED_ID , ADS.EFFECTIVE_START_DATE , ADS.EFFECTIVE_END_DATE , ADS.BUSINESS_GROUP_ID , ADS.DED_SCHED_PY_FREQ_ID , ADS.ACTY_BASE_RT_ID , ADS.DED_SCHED_RL , ADS.DED_SCHED_CD , ADS.ADS_ATTRIBUTE_CATEGORY , ADS.ADS_ATTRIBUTE1 , ADS.ADS_ATTRIBUTE2 , ADS.ADS_ATTRIBUTE3 , ADS.ADS_ATTRIBUTE4 , ADS.ADS_ATTRIBUTE5 , ADS.ADS_ATTRIBUTE6 , ADS.ADS_ATTRIBUTE7 , ADS.ADS_ATTRIBUTE8 , ADS.ADS_ATTRIBUTE9 , ADS.ADS_ATTRIBUTE10 , ADS.ADS_ATTRIBUTE11 , ADS.ADS_ATTRIBUTE12 , ADS.ADS_ATTRIBUTE13 , ADS.ADS_ATTRIBUTE14 , ADS.ADS_ATTRIBUTE15 , ADS.ADS_ATTRIBUTE16 , ADS.ADS_ATTRIBUTE17 , ADS.ADS_ATTRIBUTE18 , ADS.ADS_ATTRIBUTE19 , ADS.ADS_ATTRIBUTE20 , ADS.ADS_ATTRIBUTE21 , ADS.ADS_ATTRIBUTE22 , ADS.ADS_ATTRIBUTE23 , ADS.ADS_ATTRIBUTE24 , ADS.ADS_ATTRIBUTE25 , ADS.ADS_ATTRIBUTE26 , ADS.ADS_ATTRIBUTE27 , ADS.ADS_ATTRIBUTE28 , ADS.ADS_ATTRIBUTE29 , ADS.ADS_ATTRIBUTE30 , ADS.LAST_UPDATE_DATE , ADS.LAST_UPDATED_BY , ADS.LAST_UPDATE_LOGIN , ADS.CREATED_BY , ADS.CREATION_DATE , ADS.OBJECT_VERSION_NUMBER FROM BEN_ACTY_RT_DED_SCHED_F ADS WHERE TRUNC(SYSDATE) BETWEEN ADS.EFFECTIVE_START_DATE AND ADS.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ADS.ACTY_RT_DED_SCHED_ID
, ADS.EFFECTIVE_START_DATE
, ADS.EFFECTIVE_END_DATE
, ADS.BUSINESS_GROUP_ID
, ADS.DED_SCHED_PY_FREQ_ID
, ADS.ACTY_BASE_RT_ID
, ADS.DED_SCHED_RL
, ADS.DED_SCHED_CD
, ADS.ADS_ATTRIBUTE_CATEGORY
, ADS.ADS_ATTRIBUTE1
, ADS.ADS_ATTRIBUTE2
, ADS.ADS_ATTRIBUTE3
, ADS.ADS_ATTRIBUTE4
, ADS.ADS_ATTRIBUTE5
, ADS.ADS_ATTRIBUTE6
, ADS.ADS_ATTRIBUTE7
, ADS.ADS_ATTRIBUTE8
, ADS.ADS_ATTRIBUTE9
, ADS.ADS_ATTRIBUTE10
, ADS.ADS_ATTRIBUTE11
, ADS.ADS_ATTRIBUTE12
, ADS.ADS_ATTRIBUTE13
, ADS.ADS_ATTRIBUTE14
, ADS.ADS_ATTRIBUTE15
, ADS.ADS_ATTRIBUTE16
, ADS.ADS_ATTRIBUTE17
, ADS.ADS_ATTRIBUTE18
, ADS.ADS_ATTRIBUTE19
, ADS.ADS_ATTRIBUTE20
, ADS.ADS_ATTRIBUTE21
, ADS.ADS_ATTRIBUTE22
, ADS.ADS_ATTRIBUTE23
, ADS.ADS_ATTRIBUTE24
, ADS.ADS_ATTRIBUTE25
, ADS.ADS_ATTRIBUTE26
, ADS.ADS_ATTRIBUTE27
, ADS.ADS_ATTRIBUTE28
, ADS.ADS_ATTRIBUTE29
, ADS.ADS_ATTRIBUTE30
, ADS.LAST_UPDATE_DATE
, ADS.LAST_UPDATED_BY
, ADS.LAST_UPDATE_LOGIN
, ADS.CREATED_BY
, ADS.CREATION_DATE
, ADS.OBJECT_VERSION_NUMBER
FROM BEN_ACTY_RT_DED_SCHED_F ADS
WHERE TRUNC(SYSDATE) BETWEEN ADS.EFFECTIVE_START_DATE
AND ADS.EFFECTIVE_END_DATE