Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ACTL_PREM_VRBL_RT_RL |
SELECT AVA.ACTL_PREM_VRBL_RT_RL_ID
, AVA.EFFECTIVE_START_DATE
, AVA.EFFECTIVE_END_DATE
, AVA.ORDR_TO_APLY_NUM
, AVA.ACTL_PREM_ID
, AVA.FORMULA_ID
, AVA.BUSINESS_GROUP_ID
, AVA.AVA_ATTRIBUTE_CATEGORY
, AVA.AVA_ATTRIBUTE1
, AVA.AVA_ATTRIBUTE2
, AVA.AVA_ATTRIBUTE3
, AVA.AVA_ATTRIBUTE4
, AVA.AVA_ATTRIBUTE5
, AVA.AVA_ATTRIBUTE6
, AVA.AVA_ATTRIBUTE7
, AVA.AVA_ATTRIBUTE8
, AVA.AVA_ATTRIBUTE9
, AVA.AVA_ATTRIBUTE10
, AVA.AVA_ATTRIBUTE11
, AVA.AVA_ATTRIBUTE12
, AVA.AVA_ATTRIBUTE13
, AVA.AVA_ATTRIBUTE14
, AVA.AVA_ATTRIBUTE15
, AVA.AVA_ATTRIBUTE16
, AVA.AVA_ATTRIBUTE17
, AVA.AVA_ATTRIBUTE18
, AVA.AVA_ATTRIBUTE19
, AVA.AVA_ATTRIBUTE20
, AVA.AVA_ATTRIBUTE21
, AVA.AVA_ATTRIBUTE22
, AVA.AVA_ATTRIBUTE23
, AVA.AVA_ATTRIBUTE24
, AVA.AVA_ATTRIBUTE25
, AVA.AVA_ATTRIBUTE26
, AVA.AVA_ATTRIBUTE27
, AVA.AVA_ATTRIBUTE28
, AVA.AVA_ATTRIBUTE29
, AVA.AVA_ATTRIBUTE30
, AVA.LAST_UPDATE_DATE
, AVA.LAST_UPDATED_BY
, AVA.LAST_UPDATE_LOGIN
, AVA.CREATED_BY
, AVA.CREATION_DATE
, AVA.OBJECT_VERSION_NUMBER
FROM BEN_ACTL_PREM_VRBL_RT_RL_F AVA
WHERE AVA.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND AVA.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))