Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_VSTG_SCHED |
SELECT VSC.VSTG_SCHED_ID
, VSC.EFFECTIVE_START_DATE
, VSC.EFFECTIVE_END_DATE
, VSC.BUSINESS_GROUP_ID
, VSC.PCT_VSTD_VAL
, VSC.FORMULA_ID
, VSC.AGE_DET_RL
, VSC.BIS_RL
, VSC.LOS_DET_RL
, VSC.VSC_ATTRIBUTE_CATEGORY
, VSC.VSC_ATTRIBUTE1
, VSC.VSC_ATTRIBUTE2
, VSC.VSC_ATTRIBUTE3
, VSC.VSC_ATTRIBUTE4
, VSC.VSC_ATTRIBUTE5
, VSC.VSC_ATTRIBUTE6
, VSC.VSC_ATTRIBUTE7
, VSC.VSC_ATTRIBUTE8
, VSC.VSC_ATTRIBUTE9
, VSC.VSC_ATTRIBUTE10
, VSC.VSC_ATTRIBUTE11
, VSC.VSC_ATTRIBUTE12
, VSC.VSC_ATTRIBUTE13
, VSC.VSC_ATTRIBUTE14
, VSC.VSC_ATTRIBUTE15
, VSC.VSC_ATTRIBUTE16
, VSC.VSC_ATTRIBUTE17
, VSC.VSC_ATTRIBUTE18
, VSC.VSC_ATTRIBUTE19
, VSC.VSC_ATTRIBUTE20
, VSC.VSC_ATTRIBUTE21
, VSC.VSC_ATTRIBUTE22
, VSC.VSC_ATTRIBUTE23
, VSC.VSC_ATTRIBUTE24
, VSC.VSC_ATTRIBUTE25
, VSC.VSC_ATTRIBUTE26
, VSC.VSC_ATTRIBUTE27
, VSC.VSC_ATTRIBUTE28
, VSC.VSC_ATTRIBUTE29
, VSC.VSC_ATTRIBUTE30
, VSC.LAST_UPDATE_DATE
, VSC.LAST_UPDATED_BY
, VSC.LAST_UPDATE_LOGIN
, VSC.CREATED_BY
, VSC.CREATION_DATE
, VSC.OBJECT_VERSION_NUMBER
FROM BEN_VSTG_SCHED_F VSC
WHERE VSC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND VSC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))