VIEW: APPS.BEN_CVRD_DPNT_CTFN_PRVDD_X

Source

View Text - Preformatted

SELECT CCP.CVRD_DPNT_CTFN_PRVDD_ID , CCP.EFFECTIVE_START_DATE , CCP.EFFECTIVE_END_DATE , CCP.DPNT_DSGN_CTFN_TYP_CD , CCP.DPNT_DSGN_CTFN_RQD_FLAG , CCP.DPNT_DSGN_CTFN_RECD_DT , CCP.ELIG_CVRD_DPNT_ID , CCP.PRTT_ENRT_ACTN_ID , CCP.BUSINESS_GROUP_ID , CCP.CCP_ATTRIBUTE_CATEGORY , CCP.CCP_ATTRIBUTE1 , CCP.CCP_ATTRIBUTE2 , CCP.CCP_ATTRIBUTE3 , CCP.CCP_ATTRIBUTE4 , CCP.CCP_ATTRIBUTE5 , CCP.CCP_ATTRIBUTE6 , CCP.CCP_ATTRIBUTE7 , CCP.CCP_ATTRIBUTE8 , CCP.CCP_ATTRIBUTE9 , CCP.CCP_ATTRIBUTE10 , CCP.CCP_ATTRIBUTE11 , CCP.CCP_ATTRIBUTE12 , CCP.CCP_ATTRIBUTE13 , CCP.CCP_ATTRIBUTE14 , CCP.CCP_ATTRIBUTE15 , CCP.CCP_ATTRIBUTE16 , CCP.CCP_ATTRIBUTE17 , CCP.CCP_ATTRIBUTE18 , CCP.CCP_ATTRIBUTE19 , CCP.CCP_ATTRIBUTE20 , CCP.CCP_ATTRIBUTE21 , CCP.CCP_ATTRIBUTE22 , CCP.CCP_ATTRIBUTE23 , CCP.CCP_ATTRIBUTE24 , CCP.CCP_ATTRIBUTE25 , CCP.CCP_ATTRIBUTE26 , CCP.CCP_ATTRIBUTE27 , CCP.CCP_ATTRIBUTE28 , CCP.CCP_ATTRIBUTE29 , CCP.CCP_ATTRIBUTE30 , CCP.LAST_UPDATE_DATE , CCP.LAST_UPDATED_BY , CCP.LAST_UPDATE_LOGIN , CCP.CREATED_BY , CCP.CREATION_DATE , CCP.REQUEST_ID , CCP.PROGRAM_APPLICATION_ID , CCP.PROGRAM_ID , CCP.PROGRAM_UPDATE_DATE , CCP.OBJECT_VERSION_NUMBER FROM BEN_CVRD_DPNT_CTFN_PRVDD_F CCP WHERE TRUNC(SYSDATE) BETWEEN CCP.EFFECTIVE_START_DATE AND CCP.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT CCP.CVRD_DPNT_CTFN_PRVDD_ID
, CCP.EFFECTIVE_START_DATE
, CCP.EFFECTIVE_END_DATE
, CCP.DPNT_DSGN_CTFN_TYP_CD
, CCP.DPNT_DSGN_CTFN_RQD_FLAG
, CCP.DPNT_DSGN_CTFN_RECD_DT
, CCP.ELIG_CVRD_DPNT_ID
, CCP.PRTT_ENRT_ACTN_ID
, CCP.BUSINESS_GROUP_ID
, CCP.CCP_ATTRIBUTE_CATEGORY
, CCP.CCP_ATTRIBUTE1
, CCP.CCP_ATTRIBUTE2
, CCP.CCP_ATTRIBUTE3
, CCP.CCP_ATTRIBUTE4
, CCP.CCP_ATTRIBUTE5
, CCP.CCP_ATTRIBUTE6
, CCP.CCP_ATTRIBUTE7
, CCP.CCP_ATTRIBUTE8
, CCP.CCP_ATTRIBUTE9
, CCP.CCP_ATTRIBUTE10
, CCP.CCP_ATTRIBUTE11
, CCP.CCP_ATTRIBUTE12
, CCP.CCP_ATTRIBUTE13
, CCP.CCP_ATTRIBUTE14
, CCP.CCP_ATTRIBUTE15
, CCP.CCP_ATTRIBUTE16
, CCP.CCP_ATTRIBUTE17
, CCP.CCP_ATTRIBUTE18
, CCP.CCP_ATTRIBUTE19
, CCP.CCP_ATTRIBUTE20
, CCP.CCP_ATTRIBUTE21
, CCP.CCP_ATTRIBUTE22
, CCP.CCP_ATTRIBUTE23
, CCP.CCP_ATTRIBUTE24
, CCP.CCP_ATTRIBUTE25
, CCP.CCP_ATTRIBUTE26
, CCP.CCP_ATTRIBUTE27
, CCP.CCP_ATTRIBUTE28
, CCP.CCP_ATTRIBUTE29
, CCP.CCP_ATTRIBUTE30
, CCP.LAST_UPDATE_DATE
, CCP.LAST_UPDATED_BY
, CCP.LAST_UPDATE_LOGIN
, CCP.CREATED_BY
, CCP.CREATION_DATE
, CCP.REQUEST_ID
, CCP.PROGRAM_APPLICATION_ID
, CCP.PROGRAM_ID
, CCP.PROGRAM_UPDATE_DATE
, CCP.OBJECT_VERSION_NUMBER
FROM BEN_CVRD_DPNT_CTFN_PRVDD_F CCP
WHERE TRUNC(SYSDATE) BETWEEN CCP.EFFECTIVE_START_DATE
AND CCP.EFFECTIVE_END_DATE