View: BEN_VALD_RLSHP_FOR_REIMB

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

View Text

SELECT VRP.VALD_RLSHP_FOR_REIMB_ID
, VRP.EFFECTIVE_START_DATE
, VRP.EFFECTIVE_END_DATE
, VRP.BUSINESS_GROUP_ID
, VRP.PL_ID
, VRP.RLSHP_TYP_CD
, VRP.VRP_ATTRIBUTE_CATEGORY
, VRP.VRP_ATTRIBUTE1
, VRP.VRP_ATTRIBUTE2
, VRP.VRP_ATTRIBUTE3
, VRP.VRP_ATTRIBUTE4
, VRP.VRP_ATTRIBUTE5
, VRP.VRP_ATTRIBUTE6
, VRP.VRP_ATTRIBUTE7
, VRP.VRP_ATTRIBUTE8
, VRP.VRP_ATTRIBUTE9
, VRP.VRP_ATTRIBUTE10
, VRP.VRP_ATTRIBUTE11
, VRP.VRP_ATTRIBUTE12
, VRP.VRP_ATTRIBUTE13
, VRP.VRP_ATTRIBUTE14
, VRP.VRP_ATTRIBUTE15
, VRP.VRP_ATTRIBUTE16
, VRP.VRP_ATTRIBUTE17
, VRP.VRP_ATTRIBUTE18
, VRP.VRP_ATTRIBUTE19
, VRP.VRP_ATTRIBUTE20
, VRP.VRP_ATTRIBUTE21
, VRP.VRP_ATTRIBUTE22
, VRP.VRP_ATTRIBUTE23
, VRP.VRP_ATTRIBUTE24
, VRP.VRP_ATTRIBUTE25
, VRP.VRP_ATTRIBUTE26
, VRP.VRP_ATTRIBUTE27
, VRP.VRP_ATTRIBUTE28
, VRP.VRP_ATTRIBUTE29
, VRP.VRP_ATTRIBUTE30
, VRP.LAST_UPDATE_DATE
, VRP.LAST_UPDATED_BY
, VRP.LAST_UPDATE_LOGIN
, VRP.CREATED_BY
, VRP.CREATION_DATE
, VRP.OBJECT_VERSION_NUMBER
FROM BEN_VALD_RLSHP_FOR_REIMB_F VRP
WHERE VRP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND VRP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns