VIEW: APPS.BEN_PGM_DPNT_CVG_CTFN_V

Source

View Text - Preformatted

SELECT PGC.ROWID ROW_ID , PGC.PGM_DPNT_CVG_CTFN_ID , PGC.EFFECTIVE_START_DATE , PGC.EFFECTIVE_END_DATE , PGC.BUSINESS_GROUP_ID , PGC.PGM_ID , PGC.LACK_CTFN_SSPND_ENRT_FLAG , PGC.CTFN_RQD_WHEN_RL , PGC.PFD_FLAG , PGC.DPNT_CVG_CTFN_TYP_CD , PGC.RQD_FLAG , PGC.RLSHP_TYP_CD , PGC.PGC_ATTRIBUTE_CATEGORY , PGC.PGC_ATTRIBUTE1 , PGC.PGC_ATTRIBUTE2 , PGC.PGC_ATTRIBUTE3 , PGC.PGC_ATTRIBUTE4 , PGC.PGC_ATTRIBUTE5 , PGC.PGC_ATTRIBUTE6 , PGC.PGC_ATTRIBUTE7 , PGC.PGC_ATTRIBUTE8 , PGC.PGC_ATTRIBUTE9 , PGC.PGC_ATTRIBUTE10 , PGC.PGC_ATTRIBUTE11 , PGC.PGC_ATTRIBUTE12 , PGC.PGC_ATTRIBUTE13 , PGC.PGC_ATTRIBUTE14 , PGC.PGC_ATTRIBUTE15 , PGC.PGC_ATTRIBUTE16 , PGC.PGC_ATTRIBUTE17 , PGC.PGC_ATTRIBUTE18 , PGC.PGC_ATTRIBUTE19 , PGC.PGC_ATTRIBUTE20 , PGC.PGC_ATTRIBUTE21 , PGC.PGC_ATTRIBUTE22 , PGC.PGC_ATTRIBUTE23 , PGC.PGC_ATTRIBUTE24 , PGC.PGC_ATTRIBUTE25 , PGC.PGC_ATTRIBUTE26 , PGC.PGC_ATTRIBUTE27 , PGC.PGC_ATTRIBUTE28 , PGC.PGC_ATTRIBUTE29 , PGC.PGC_ATTRIBUTE30 , PGC.LAST_UPDATE_DATE , PGC.LAST_UPDATED_BY , PGC.LAST_UPDATE_LOGIN , PGC.CREATED_BY , PGC.CREATION_DATE , PGC.OBJECT_VERSION_NUMBER FROM BEN_PGM_DPNT_CVG_CTFN_F PGC, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN PGC.EFFECTIVE_START_DATE AND PGC.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PGC.ROWID ROW_ID
, PGC.PGM_DPNT_CVG_CTFN_ID
, PGC.EFFECTIVE_START_DATE
, PGC.EFFECTIVE_END_DATE
, PGC.BUSINESS_GROUP_ID
, PGC.PGM_ID
, PGC.LACK_CTFN_SSPND_ENRT_FLAG
, PGC.CTFN_RQD_WHEN_RL
, PGC.PFD_FLAG
, PGC.DPNT_CVG_CTFN_TYP_CD
, PGC.RQD_FLAG
, PGC.RLSHP_TYP_CD
, PGC.PGC_ATTRIBUTE_CATEGORY
, PGC.PGC_ATTRIBUTE1
, PGC.PGC_ATTRIBUTE2
, PGC.PGC_ATTRIBUTE3
, PGC.PGC_ATTRIBUTE4
, PGC.PGC_ATTRIBUTE5
, PGC.PGC_ATTRIBUTE6
, PGC.PGC_ATTRIBUTE7
, PGC.PGC_ATTRIBUTE8
, PGC.PGC_ATTRIBUTE9
, PGC.PGC_ATTRIBUTE10
, PGC.PGC_ATTRIBUTE11
, PGC.PGC_ATTRIBUTE12
, PGC.PGC_ATTRIBUTE13
, PGC.PGC_ATTRIBUTE14
, PGC.PGC_ATTRIBUTE15
, PGC.PGC_ATTRIBUTE16
, PGC.PGC_ATTRIBUTE17
, PGC.PGC_ATTRIBUTE18
, PGC.PGC_ATTRIBUTE19
, PGC.PGC_ATTRIBUTE20
, PGC.PGC_ATTRIBUTE21
, PGC.PGC_ATTRIBUTE22
, PGC.PGC_ATTRIBUTE23
, PGC.PGC_ATTRIBUTE24
, PGC.PGC_ATTRIBUTE25
, PGC.PGC_ATTRIBUTE26
, PGC.PGC_ATTRIBUTE27
, PGC.PGC_ATTRIBUTE28
, PGC.PGC_ATTRIBUTE29
, PGC.PGC_ATTRIBUTE30
, PGC.LAST_UPDATE_DATE
, PGC.LAST_UPDATED_BY
, PGC.LAST_UPDATE_LOGIN
, PGC.CREATED_BY
, PGC.CREATION_DATE
, PGC.OBJECT_VERSION_NUMBER
FROM BEN_PGM_DPNT_CVG_CTFN_F PGC
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PGC.EFFECTIVE_START_DATE
AND PGC.EFFECTIVE_END_DATE