VIEW: APPS.BEN_CNTNU_PRTN_CTFN_TYP

Source

View Text - Preformatted

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

View Text - HTML Formatted

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