Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_VALD_RLSHP_FOR_REIMB_V |
SELECT VRP.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN VRP.EFFECTIVE_START_DATE
AND VRP.EFFECTIVE_END_DATE