Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_CNTNU_PRTN_CTFN_TYP_V |
SELECT CPC.ROWID ROW_ID
, CPC.CNTNU_PRTN_CTFN_TYP_ID
, CPC.EFFECTIVE_START_DATE
, CPC.EFFECTIVE_END_DATE
, CPC.BUSINESS_GROUP_ID
, CPC.CNTNG_PRTN_ELIG_PRFL_ID
, CPC.PFD_FLAG
, CPC.LACK_CTFN_SSPND_ELIG_FLAG
, CPC.CTFN_RQD_WHEN_RL
, CPC.PRTN_CTFN_TYP_CD
, CPC.CPC_ATTRIBUTE_CATEGORY
, CPC.CPC_ATTRIBUTE1
, CPC.CPC_ATTRIBUTE2
, CPC.CPC_ATTRIBUTE3
, CPC.CPC_ATTRIBUTE4
, CPC.CPC_ATTRIBUTE5
, CPC.CPC_ATTRIBUTE6
, CPC.CPC_ATTRIBUTE7
, CPC.CPC_ATTRIBUTE8
, CPC.CPC_ATTRIBUTE9
, CPC.CPC_ATTRIBUTE10
, CPC.CPC_ATTRIBUTE11
, CPC.CPC_ATTRIBUTE12
, CPC.CPC_ATTRIBUTE13
, CPC.CPC_ATTRIBUTE14
, CPC.CPC_ATTRIBUTE15
, CPC.CPC_ATTRIBUTE16
, CPC.CPC_ATTRIBUTE17
, CPC.CPC_ATTRIBUTE18
, CPC.CPC_ATTRIBUTE19
, CPC.CPC_ATTRIBUTE20
, CPC.CPC_ATTRIBUTE21
, CPC.CPC_ATTRIBUTE22
, CPC.CPC_ATTRIBUTE23
, CPC.CPC_ATTRIBUTE24
, CPC.CPC_ATTRIBUTE25
, CPC.CPC_ATTRIBUTE26
, CPC.CPC_ATTRIBUTE27
, CPC.CPC_ATTRIBUTE28
, CPC.CPC_ATTRIBUTE29
, CPC.CPC_ATTRIBUTE30
, CPC.LAST_UPDATE_DATE
, CPC.LAST_UPDATED_BY
, CPC.LAST_UPDATE_LOGIN
, CPC.CREATED_BY
, CPC.CREATION_DATE
, CPC.OBJECT_VERSION_NUMBER
FROM BEN_CNTNU_PRTN_CTFN_TYP_F CPC
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CPC.EFFECTIVE_START_DATE
AND CPC.EFFECTIVE_END_DATE