VIEW: APPS.BEN_APLCN_TO_BNFT_POOL

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))