View: BEN_BNFT_RSTRN_CTFN

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_BNFT_RSTRN_CTFN

View Text

SELECT BRC.BNFT_RSTRN_CTFN_ID
, BRC.EFFECTIVE_START_DATE
, BRC.EFFECTIVE_END_DATE
, BRC.RQD_FLAG
, BRC.ENRT_CTFN_TYP_CD
, BRC.CTFN_RQD_WHEN_RL
, BRC.PL_ID
, BRC.BUSINESS_GROUP_ID
, BRC.BRC_ATTRIBUTE_CATEGORY
, BRC.BRC_ATTRIBUTE1
, BRC.BRC_ATTRIBUTE2
, BRC.BRC_ATTRIBUTE3
, BRC.BRC_ATTRIBUTE4
, BRC.BRC_ATTRIBUTE5
, BRC.BRC_ATTRIBUTE6
, BRC.BRC_ATTRIBUTE7
, BRC.BRC_ATTRIBUTE8
, BRC.BRC_ATTRIBUTE9
, BRC.BRC_ATTRIBUTE10
, BRC.BRC_ATTRIBUTE11
, BRC.BRC_ATTRIBUTE12
, BRC.BRC_ATTRIBUTE13
, BRC.BRC_ATTRIBUTE14
, BRC.BRC_ATTRIBUTE15
, BRC.BRC_ATTRIBUTE16
, BRC.BRC_ATTRIBUTE17
, BRC.BRC_ATTRIBUTE18
, BRC.BRC_ATTRIBUTE19
, BRC.BRC_ATTRIBUTE20
, BRC.BRC_ATTRIBUTE21
, BRC.BRC_ATTRIBUTE22
, BRC.BRC_ATTRIBUTE23
, BRC.BRC_ATTRIBUTE24
, BRC.BRC_ATTRIBUTE25
, BRC.BRC_ATTRIBUTE26
, BRC.BRC_ATTRIBUTE27
, BRC.BRC_ATTRIBUTE28
, BRC.BRC_ATTRIBUTE29
, BRC.BRC_ATTRIBUTE30
, BRC.LAST_UPDATE_DATE
, BRC.LAST_UPDATED_BY
, BRC.LAST_UPDATE_LOGIN
, BRC.CREATED_BY
, BRC.CREATION_DATE
, BRC.OBJECT_VERSION_NUMBER
FROM BEN_BNFT_RSTRN_CTFN_F BRC
WHERE BRC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND BRC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns