Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_WV_PRTN_RSN_PL_X |
SELECT WPN.WV_PRTN_RSN_PL_ID
, WPN.EFFECTIVE_START_DATE
, WPN.EFFECTIVE_END_DATE
, WPN.BUSINESS_GROUP_ID
, WPN.PL_ID
, WPN.DFLT_FLAG
, WPN.WV_PRTN_RSN_CD
, WPN.WPN_ATTRIBUTE_CATEGORY
, WPN.WPN_ATTRIBUTE1
, WPN.WPN_ATTRIBUTE2
, WPN.WPN_ATTRIBUTE3
, WPN.WPN_ATTRIBUTE4
, WPN.WPN_ATTRIBUTE5
, WPN.WPN_ATTRIBUTE6
, WPN.WPN_ATTRIBUTE7
, WPN.WPN_ATTRIBUTE8
, WPN.WPN_ATTRIBUTE9
, WPN.WPN_ATTRIBUTE10
, WPN.WPN_ATTRIBUTE11
, WPN.WPN_ATTRIBUTE12
, WPN.WPN_ATTRIBUTE13
, WPN.WPN_ATTRIBUTE14
, WPN.WPN_ATTRIBUTE15
, WPN.WPN_ATTRIBUTE16
, WPN.WPN_ATTRIBUTE17
, WPN.WPN_ATTRIBUTE18
, WPN.WPN_ATTRIBUTE19
, WPN.WPN_ATTRIBUTE20
, WPN.WPN_ATTRIBUTE21
, WPN.WPN_ATTRIBUTE22
, WPN.WPN_ATTRIBUTE23
, WPN.WPN_ATTRIBUTE24
, WPN.WPN_ATTRIBUTE25
, WPN.WPN_ATTRIBUTE26
, WPN.WPN_ATTRIBUTE27
, WPN.WPN_ATTRIBUTE28
, WPN.WPN_ATTRIBUTE29
, WPN.WPN_ATTRIBUTE30
, WPN.LAST_UPDATE_DATE
, WPN.LAST_UPDATED_BY
, WPN.LAST_UPDATE_LOGIN
, WPN.CREATED_BY
, WPN.CREATION_DATE
, WPN.OBJECT_VERSION_NUMBER
FROM BEN_WV_PRTN_RSN_PL_F WPN
WHERE TRUNC(SYSDATE) BETWEEN WPN.EFFECTIVE_START_DATE
AND WPN.EFFECTIVE_END_DATE