VIEW: APPS.BEN_WV_PRTN_RSN_CTFN_PTIP

Source

View Text - Preformatted

SELECT 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 WHERE WCT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND WCT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT 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
WHERE WCT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND WCT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))