VIEW: APPS.BEN_CNTNU_PRTN_CTFN_TYP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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