Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_CMBN_PTIP_OPT_V |
SELECT CPT.ROWID ROW_ID
, CPT.CMBN_PTIP_OPT_ID
, CPT.EFFECTIVE_START_DATE
, CPT.EFFECTIVE_END_DATE
, CPT.PTIP_ID
, CPT.NAME
, CPT.BUSINESS_GROUP_ID
, CPT.CPT_ATTRIBUTE_CATEGORY
, CPT.CPT_ATTRIBUTE1
, CPT.CPT_ATTRIBUTE2
, CPT.CPT_ATTRIBUTE3
, CPT.CPT_ATTRIBUTE4
, CPT.CPT_ATTRIBUTE5
, CPT.CPT_ATTRIBUTE6
, CPT.CPT_ATTRIBUTE7
, CPT.CPT_ATTRIBUTE8
, CPT.CPT_ATTRIBUTE9
, CPT.CPT_ATTRIBUTE10
, CPT.CPT_ATTRIBUTE11
, CPT.CPT_ATTRIBUTE12
, CPT.CPT_ATTRIBUTE13
, CPT.CPT_ATTRIBUTE14
, CPT.CPT_ATTRIBUTE15
, CPT.CPT_ATTRIBUTE16
, CPT.CPT_ATTRIBUTE17
, CPT.CPT_ATTRIBUTE18
, CPT.CPT_ATTRIBUTE19
, CPT.CPT_ATTRIBUTE20
, CPT.CPT_ATTRIBUTE21
, CPT.CPT_ATTRIBUTE22
, CPT.CPT_ATTRIBUTE23
, CPT.CPT_ATTRIBUTE24
, CPT.CPT_ATTRIBUTE25
, CPT.CPT_ATTRIBUTE26
, CPT.CPT_ATTRIBUTE27
, CPT.CPT_ATTRIBUTE28
, CPT.CPT_ATTRIBUTE29
, CPT.CPT_ATTRIBUTE30
, CPT.LAST_UPDATE_DATE
, CPT.LAST_UPDATED_BY
, CPT.LAST_UPDATE_LOGIN
, CPT.CREATED_BY
, CPT.CREATION_DATE
, CPT.OBJECT_VERSION_NUMBER
, CPT.PGM_ID
, CPT.OPT_ID
FROM BEN_CMBN_PTIP_OPT_F CPT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CPT.EFFECTIVE_START_DATE
AND CPT.EFFECTIVE_END_DATE