VIEW: APPS.BEN_VALD_RLSHP_FOR_REIMB

Source

View Text - Preformatted

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

View Text - HTML Formatted

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