Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PGM_DPNT_CVG_CTFN |
SELECT 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
WHERE PGC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PGC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))