Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ACTY_RT_DED_SCHED_V |
SELECT ADS.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ADS.EFFECTIVE_START_DATE
AND ADS.EFFECTIVE_END_DATE