Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_CMBN_PLIP |
SELECT CPL.CMBN_PLIP_ID
, CPL.EFFECTIVE_START_DATE
, CPL.EFFECTIVE_END_DATE
, CPL.NAME
, CPL.PGM_ID
, CPL.BUSINESS_GROUP_ID
, CPL.CPL_ATTRIBUTE_CATEGORY
, CPL.CPL_ATTRIBUTE1
, CPL.CPL_ATTRIBUTE2
, CPL.CPL_ATTRIBUTE3
, CPL.CPL_ATTRIBUTE4
, CPL.CPL_ATTRIBUTE5
, CPL.CPL_ATTRIBUTE6
, CPL.CPL_ATTRIBUTE7
, CPL.CPL_ATTRIBUTE8
, CPL.CPL_ATTRIBUTE9
, CPL.CPL_ATTRIBUTE10
, CPL.CPL_ATTRIBUTE11
, CPL.CPL_ATTRIBUTE12
, CPL.CPL_ATTRIBUTE13
, CPL.CPL_ATTRIBUTE14
, CPL.CPL_ATTRIBUTE15
, CPL.CPL_ATTRIBUTE16
, CPL.CPL_ATTRIBUTE17
, CPL.CPL_ATTRIBUTE18
, CPL.CPL_ATTRIBUTE19
, CPL.CPL_ATTRIBUTE20
, CPL.CPL_ATTRIBUTE21
, CPL.CPL_ATTRIBUTE22
, CPL.CPL_ATTRIBUTE23
, CPL.CPL_ATTRIBUTE24
, CPL.CPL_ATTRIBUTE25
, CPL.CPL_ATTRIBUTE26
, CPL.CPL_ATTRIBUTE27
, CPL.CPL_ATTRIBUTE28
, CPL.CPL_ATTRIBUTE29
, CPL.CPL_ATTRIBUTE30
, CPL.LAST_UPDATE_DATE
, CPL.LAST_UPDATED_BY
, CPL.LAST_UPDATE_LOGIN
, CPL.CREATED_BY
, CPL.CREATION_DATE
, CPL.OBJECT_VERSION_NUMBER
FROM BEN_CMBN_PLIP_F CPL
WHERE CPL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CPL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))