VIEW: APPS.BEN_CNTNG_PRTN_PRFL_RT_V

Source

View Text - Preformatted

SELECT CPN.ROWID, CPN.CNTNG_PRTN_PRFL_RT_ID, CPN.EFFECTIVE_START_DATE, CPN.EFFECTIVE_END_DATE, CPN.VRBL_RT_PRFL_ID, CPN.BUSINESS_GROUP_ID, CPN.NAME , CPN.PYMT_MUST_BE_RCVD_UOM , CPN.PYMT_MUST_BE_RCVD_NUM , CPN.PYMT_MUST_BE_RCVD_RL, CPN.CPN_ATTRIBUTE_CATEGORY, CPN.CPN_ATTRIBUTE1 , CPN.CPN_ATTRIBUTE2 , CPN.CPN_ATTRIBUTE3 , CPN.CPN_ATTRIBUTE4 , CPN.CPN_ATTRIBUTE5 , CPN.CPN_ATTRIBUTE6 , CPN.CPN_ATTRIBUTE7 , CPN.CPN_ATTRIBUTE8 , CPN.CPN_ATTRIBUTE9 , CPN.CPN_ATTRIBUTE10 , CPN.CPN_ATTRIBUTE11 , CPN.CPN_ATTRIBUTE12 , CPN.CPN_ATTRIBUTE13 , CPN.CPN_ATTRIBUTE14 , CPN.CPN_ATTRIBUTE15 , CPN.CPN_ATTRIBUTE16 , CPN.CPN_ATTRIBUTE17 , CPN.CPN_ATTRIBUTE18 , CPN.CPN_ATTRIBUTE19 , CPN.CPN_ATTRIBUTE20 , CPN.CPN_ATTRIBUTE21 , CPN.CPN_ATTRIBUTE22 , CPN.CPN_ATTRIBUTE23 , CPN.CPN_ATTRIBUTE24 , CPN.CPN_ATTRIBUTE25 , CPN.CPN_ATTRIBUTE26 , CPN.CPN_ATTRIBUTE27 , CPN.CPN_ATTRIBUTE28 , CPN.CPN_ATTRIBUTE29 , CPN.CPN_ATTRIBUTE30 , CPN.LAST_UPDATE_DATE, CPN.LAST_UPDATED_BY , CPN.LAST_UPDATE_LOGIN, CPN.CREATED_BY , CPN.CREATION_DATE , CPN.OBJECT_VERSION_NUMBER FROM BEN_CNTNG_PRTN_PRFL_RT_F CPN, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('SESSIONID') AND SE.EFFECTIVE_DATE BETWEEN CPN.EFFECTIVE_START_DATE AND CPN.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT CPN.ROWID
, CPN.CNTNG_PRTN_PRFL_RT_ID
, CPN.EFFECTIVE_START_DATE
, CPN.EFFECTIVE_END_DATE
, CPN.VRBL_RT_PRFL_ID
, CPN.BUSINESS_GROUP_ID
, CPN.NAME
, CPN.PYMT_MUST_BE_RCVD_UOM
, CPN.PYMT_MUST_BE_RCVD_NUM
, CPN.PYMT_MUST_BE_RCVD_RL
, CPN.CPN_ATTRIBUTE_CATEGORY
, CPN.CPN_ATTRIBUTE1
, CPN.CPN_ATTRIBUTE2
, CPN.CPN_ATTRIBUTE3
, CPN.CPN_ATTRIBUTE4
, CPN.CPN_ATTRIBUTE5
, CPN.CPN_ATTRIBUTE6
, CPN.CPN_ATTRIBUTE7
, CPN.CPN_ATTRIBUTE8
, CPN.CPN_ATTRIBUTE9
, CPN.CPN_ATTRIBUTE10
, CPN.CPN_ATTRIBUTE11
, CPN.CPN_ATTRIBUTE12
, CPN.CPN_ATTRIBUTE13
, CPN.CPN_ATTRIBUTE14
, CPN.CPN_ATTRIBUTE15
, CPN.CPN_ATTRIBUTE16
, CPN.CPN_ATTRIBUTE17
, CPN.CPN_ATTRIBUTE18
, CPN.CPN_ATTRIBUTE19
, CPN.CPN_ATTRIBUTE20
, CPN.CPN_ATTRIBUTE21
, CPN.CPN_ATTRIBUTE22
, CPN.CPN_ATTRIBUTE23
, CPN.CPN_ATTRIBUTE24
, CPN.CPN_ATTRIBUTE25
, CPN.CPN_ATTRIBUTE26
, CPN.CPN_ATTRIBUTE27
, CPN.CPN_ATTRIBUTE28
, CPN.CPN_ATTRIBUTE29
, CPN.CPN_ATTRIBUTE30
, CPN.LAST_UPDATE_DATE
, CPN.LAST_UPDATED_BY
, CPN.LAST_UPDATE_LOGIN
, CPN.CREATED_BY
, CPN.CREATION_DATE
, CPN.OBJECT_VERSION_NUMBER
FROM BEN_CNTNG_PRTN_PRFL_RT_F CPN
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CPN.EFFECTIVE_START_DATE
AND CPN.EFFECTIVE_END_DATE