Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_WV_PRTN_RSN_CTFN_PTIP_V |
SELECT WCT.ROWID ROW_ID
, WCT.WV_PRTN_RSN_CTFN_PTIP_ID
, WCT.EFFECTIVE_START_DATE
, WCT.EFFECTIVE_END_DATE
, WCT.WV_PRTN_CTFN_CD
, WCT.WV_PRTN_RSN_PTIP_ID
, WCT.LACK_CTFN_SSPND_WVR_FLAG
, WCT.RQD_FLAG
, WCT.CTFN_RQD_WHEN_RL
, WCT.PFD_FLAG
, WCT.WV_PRTN_CTFN_TYP_CD
, WCT.BUSINESS_GROUP_ID
, WCT.WCT_ATTRIBUTE_CATEGORY
, WCT.WCT_ATTRIBUTE1
, WCT.WCT_ATTRIBUTE2
, WCT.WCT_ATTRIBUTE3
, WCT.WCT_ATTRIBUTE4
, WCT.WCT_ATTRIBUTE5
, WCT.WCT_ATTRIBUTE6
, WCT.WCT_ATTRIBUTE7
, WCT.WCT_ATTRIBUTE8
, WCT.WCT_ATTRIBUTE9
, WCT.WCT_ATTRIBUTE10
, WCT.WCT_ATTRIBUTE11
, WCT.WCT_ATTRIBUTE12
, WCT.WCT_ATTRIBUTE13
, WCT.WCT_ATTRIBUTE14
, WCT.WCT_ATTRIBUTE15
, WCT.WCT_ATTRIBUTE16
, WCT.WCT_ATTRIBUTE17
, WCT.WCT_ATTRIBUTE18
, WCT.WCT_ATTRIBUTE19
, WCT.WCT_ATTRIBUTE20
, WCT.WCT_ATTRIBUTE21
, WCT.WCT_ATTRIBUTE22
, WCT.WCT_ATTRIBUTE23
, WCT.WCT_ATTRIBUTE24
, WCT.WCT_ATTRIBUTE25
, WCT.WCT_ATTRIBUTE26
, WCT.WCT_ATTRIBUTE27
, WCT.WCT_ATTRIBUTE28
, WCT.WCT_ATTRIBUTE29
, WCT.WCT_ATTRIBUTE30
, WCT.LAST_UPDATE_DATE
, WCT.LAST_UPDATED_BY
, WCT.LAST_UPDATE_LOGIN
, WCT.CREATED_BY
, WCT.CREATION_DATE
, WCT.OBJECT_VERSION_NUMBER
FROM BEN_WV_PRTN_RSN_CTFN_PTIP_F WCT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN WCT.EFFECTIVE_START_DATE
AND WCT.EFFECTIVE_END_DATE