Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_APLCN_TO_BNFT_POOL |
SELECT ABP.APLCN_TO_BNFT_POOL_ID
, ABP.EFFECTIVE_START_DATE
, ABP.EFFECTIVE_END_DATE
, ABP.ACTY_BASE_RT_ID
, ABP.BNFT_PRVDR_POOL_ID
, ABP.BUSINESS_GROUP_ID
, ABP.ABP_ATTRIBUTE_CATEGORY
, ABP.ABP_ATTRIBUTE1
, ABP.ABP_ATTRIBUTE2
, ABP.ABP_ATTRIBUTE3
, ABP.ABP_ATTRIBUTE4
, ABP.ABP_ATTRIBUTE5
, ABP.ABP_ATTRIBUTE6
, ABP.ABP_ATTRIBUTE7
, ABP.ABP_ATTRIBUTE8
, ABP.ABP_ATTRIBUTE9
, ABP.ABP_ATTRIBUTE10
, ABP.ABP_ATTRIBUTE11
, ABP.ABP_ATTRIBUTE12
, ABP.ABP_ATTRIBUTE13
, ABP.ABP_ATTRIBUTE14
, ABP.ABP_ATTRIBUTE15
, ABP.ABP_ATTRIBUTE16
, ABP.ABP_ATTRIBUTE17
, ABP.ABP_ATTRIBUTE18
, ABP.ABP_ATTRIBUTE19
, ABP.ABP_ATTRIBUTE20
, ABP.ABP_ATTRIBUTE21
, ABP.ABP_ATTRIBUTE22
, ABP.ABP_ATTRIBUTE23
, ABP.ABP_ATTRIBUTE24
, ABP.ABP_ATTRIBUTE25
, ABP.ABP_ATTRIBUTE26
, ABP.ABP_ATTRIBUTE27
, ABP.ABP_ATTRIBUTE28
, ABP.ABP_ATTRIBUTE29
, ABP.ABP_ATTRIBUTE30
, ABP.LAST_UPDATE_DATE
, ABP.LAST_UPDATED_BY
, ABP.LAST_UPDATE_LOGIN
, ABP.CREATED_BY
, ABP.CREATION_DATE
, ABP.OBJECT_VERSION_NUMBER
FROM BEN_APLCN_TO_BNFT_POOL_F ABP
WHERE ABP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ABP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))