Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_LER_CHG_PL_NIP_RL_V |
SELECT LNR.ROWID ROW_ID
, LNR.LER_CHG_PL_NIP_RL_ID
, LNR.EFFECTIVE_START_DATE
, LNR.EFFECTIVE_END_DATE
, LNR.BUSINESS_GROUP_ID
, LNR.FORMULA_ID
, LNR.ORDR_TO_APLY_NUM
, LNR.LER_CHG_PL_NIP_ENRT_ID
, LNR.LNR_ATTRIBUTE_CATEGORY
, LNR.LNR_ATTRIBUTE1
, LNR.LNR_ATTRIBUTE2
, LNR.LNR_ATTRIBUTE3
, LNR.LNR_ATTRIBUTE4
, LNR.LNR_ATTRIBUTE5
, LNR.LNR_ATTRIBUTE6
, LNR.LNR_ATTRIBUTE7
, LNR.LNR_ATTRIBUTE8
, LNR.LNR_ATTRIBUTE9
, LNR.LNR_ATTRIBUTE10
, LNR.LNR_ATTRIBUTE11
, LNR.LNR_ATTRIBUTE12
, LNR.LNR_ATTRIBUTE13
, LNR.LNR_ATTRIBUTE14
, LNR.LNR_ATTRIBUTE15
, LNR.LNR_ATTRIBUTE16
, LNR.LNR_ATTRIBUTE17
, LNR.LNR_ATTRIBUTE18
, LNR.LNR_ATTRIBUTE19
, LNR.LNR_ATTRIBUTE20
, LNR.LNR_ATTRIBUTE21
, LNR.LNR_ATTRIBUTE22
, LNR.LNR_ATTRIBUTE23
, LNR.LNR_ATTRIBUTE24
, LNR.LNR_ATTRIBUTE25
, LNR.LNR_ATTRIBUTE26
, LNR.LNR_ATTRIBUTE27
, LNR.LNR_ATTRIBUTE28
, LNR.LNR_ATTRIBUTE29
, LNR.LNR_ATTRIBUTE30
, LNR.LAST_UPDATE_DATE
, LNR.LAST_UPDATED_BY
, LNR.LAST_UPDATE_LOGIN
, LNR.CREATED_BY
, LNR.CREATION_DATE
, LNR.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_PL_NIP_RL_F LNR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LNR.EFFECTIVE_START_DATE
AND LNR.EFFECTIVE_END_DATE