VIEW: APPS.BEN_CNTNG_PRTN_ELIG_PRFL

Source

View Text - Preformatted

SELECT CGP.CNTNG_PRTN_ELIG_PRFL_ID , CGP.EFFECTIVE_START_DATE , CGP.EFFECTIVE_END_DATE , CGP.ELIGY_PRFL_ID , CGP.NAME , CGP.PYMT_MUST_BE_RCVD_UOM , CGP.PYMT_MUST_BE_RCVD_NUM , CGP.PYMT_MUST_BE_RCVD_RL , CGP.BUSINESS_GROUP_ID , CGP.CGP_ATTRIBUTE_CATEGORY , CGP.CGP_ATTRIBUTE1 , CGP.CGP_ATTRIBUTE2 , CGP.CGP_ATTRIBUTE3 , CGP.CGP_ATTRIBUTE4 , CGP.CGP_ATTRIBUTE5 , CGP.CGP_ATTRIBUTE6 , CGP.CGP_ATTRIBUTE7 , CGP.CGP_ATTRIBUTE8 , CGP.CGP_ATTRIBUTE9 , CGP.CGP_ATTRIBUTE10 , CGP.CGP_ATTRIBUTE11 , CGP.CGP_ATTRIBUTE12 , CGP.CGP_ATTRIBUTE13 , CGP.CGP_ATTRIBUTE14 , CGP.CGP_ATTRIBUTE15 , CGP.CGP_ATTRIBUTE16 , CGP.CGP_ATTRIBUTE17 , CGP.CGP_ATTRIBUTE18 , CGP.CGP_ATTRIBUTE19 , CGP.CGP_ATTRIBUTE20 , CGP.CGP_ATTRIBUTE21 , CGP.CGP_ATTRIBUTE22 , CGP.CGP_ATTRIBUTE23 , CGP.CGP_ATTRIBUTE24 , CGP.CGP_ATTRIBUTE25 , CGP.CGP_ATTRIBUTE26 , CGP.CGP_ATTRIBUTE27 , CGP.CGP_ATTRIBUTE28 , CGP.CGP_ATTRIBUTE29 , CGP.CGP_ATTRIBUTE30 , CGP.LAST_UPDATE_DATE , CGP.LAST_UPDATED_BY , CGP.LAST_UPDATE_LOGIN , CGP.CREATED_BY , CGP.CREATION_DATE , CGP.OBJECT_VERSION_NUMBER FROM BEN_CNTNG_PRTN_ELIG_PRFL_F CGP WHERE CGP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND CGP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT CGP.CNTNG_PRTN_ELIG_PRFL_ID
, CGP.EFFECTIVE_START_DATE
, CGP.EFFECTIVE_END_DATE
, CGP.ELIGY_PRFL_ID
, CGP.NAME
, CGP.PYMT_MUST_BE_RCVD_UOM
, CGP.PYMT_MUST_BE_RCVD_NUM
, CGP.PYMT_MUST_BE_RCVD_RL
, CGP.BUSINESS_GROUP_ID
, CGP.CGP_ATTRIBUTE_CATEGORY
, CGP.CGP_ATTRIBUTE1
, CGP.CGP_ATTRIBUTE2
, CGP.CGP_ATTRIBUTE3
, CGP.CGP_ATTRIBUTE4
, CGP.CGP_ATTRIBUTE5
, CGP.CGP_ATTRIBUTE6
, CGP.CGP_ATTRIBUTE7
, CGP.CGP_ATTRIBUTE8
, CGP.CGP_ATTRIBUTE9
, CGP.CGP_ATTRIBUTE10
, CGP.CGP_ATTRIBUTE11
, CGP.CGP_ATTRIBUTE12
, CGP.CGP_ATTRIBUTE13
, CGP.CGP_ATTRIBUTE14
, CGP.CGP_ATTRIBUTE15
, CGP.CGP_ATTRIBUTE16
, CGP.CGP_ATTRIBUTE17
, CGP.CGP_ATTRIBUTE18
, CGP.CGP_ATTRIBUTE19
, CGP.CGP_ATTRIBUTE20
, CGP.CGP_ATTRIBUTE21
, CGP.CGP_ATTRIBUTE22
, CGP.CGP_ATTRIBUTE23
, CGP.CGP_ATTRIBUTE24
, CGP.CGP_ATTRIBUTE25
, CGP.CGP_ATTRIBUTE26
, CGP.CGP_ATTRIBUTE27
, CGP.CGP_ATTRIBUTE28
, CGP.CGP_ATTRIBUTE29
, CGP.CGP_ATTRIBUTE30
, CGP.LAST_UPDATE_DATE
, CGP.LAST_UPDATED_BY
, CGP.LAST_UPDATE_LOGIN
, CGP.CREATED_BY
, CGP.CREATION_DATE
, CGP.OBJECT_VERSION_NUMBER
FROM BEN_CNTNG_PRTN_ELIG_PRFL_F CGP
WHERE CGP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CGP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))