Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_APLCN_TO_BNFT_POOL_V |
SELECT ABP.ROWID ROW_ID
, ABP.APLCN_TO_BNFT_POOL_ID
, ABP.EFFECTIVE_START_DATE
, ABP.EFFECTIVE_END_DATE
, ABP.ACTY_BASE_RT_ID
, ABP.BNFT_PRVDR_POOL_ID
, ABP.BUSINESS_GROUP_ID
, ABP.ABP_ATTRIBUTE_CATEGORY
, ABP.ABP_ATTRIBUTE1
, ABP.ABP_ATTRIBUTE2
, ABP.ABP_ATTRIBUTE3
, ABP.ABP_ATTRIBUTE4
, ABP.ABP_ATTRIBUTE5
, ABP.ABP_ATTRIBUTE6
, ABP.ABP_ATTRIBUTE7
, ABP.ABP_ATTRIBUTE8
, ABP.ABP_ATTRIBUTE9
, ABP.ABP_ATTRIBUTE10
, ABP.ABP_ATTRIBUTE11
, ABP.ABP_ATTRIBUTE12
, ABP.ABP_ATTRIBUTE13
, ABP.ABP_ATTRIBUTE14
, ABP.ABP_ATTRIBUTE15
, ABP.ABP_ATTRIBUTE16
, ABP.ABP_ATTRIBUTE17
, ABP.ABP_ATTRIBUTE18
, ABP.ABP_ATTRIBUTE19
, ABP.ABP_ATTRIBUTE20
, ABP.ABP_ATTRIBUTE21
, ABP.ABP_ATTRIBUTE22
, ABP.ABP_ATTRIBUTE23
, ABP.ABP_ATTRIBUTE24
, ABP.ABP_ATTRIBUTE25
, ABP.ABP_ATTRIBUTE26
, ABP.ABP_ATTRIBUTE27
, ABP.ABP_ATTRIBUTE28
, ABP.ABP_ATTRIBUTE29
, ABP.ABP_ATTRIBUTE30
, ABP.LAST_UPDATE_DATE
, ABP.LAST_UPDATED_BY
, ABP.LAST_UPDATE_LOGIN
, ABP.CREATED_BY
, ABP.CREATION_DATE
, ABP.OBJECT_VERSION_NUMBER
, BENUTILS.BEN_GET_ABP_PLAN_OPT_NAMES(ABP.BNFT_PRVDR_POOL_ID
, ABP.BUSINESS_GROUP_ID
, ABP.ACTY_BASE_RT_ID
, SE.SESSION_ID
, 'PLAN') "PLAN_NAME"
, BENUTILS.BEN_GET_ABP_PLAN_OPT_NAMES(ABP.BNFT_PRVDR_POOL_ID
, ABP.BUSINESS_GROUP_ID
, ABP.ACTY_BASE_RT_ID
, SE.SESSION_ID
, 'OPTION') "OPTION_NAME"
, BENUTILS.BEN_GET_ABP_PLAN_OPT_NAMES(ABP.BNFT_PRVDR_POOL_ID
, ABP.BUSINESS_GROUP_ID
, ABP.ACTY_BASE_RT_ID
, SE.SESSION_ID
, 'ACTIVITY') "ACTY_BASE_RATE_NAME"
, BENUTILS.BEN_GET_ABP_PLAN_OPT_NAMES(ABP.BNFT_PRVDR_POOL_ID
, ABP.BUSINESS_GROUP_ID
, ABP.ACTY_BASE_RT_ID
, SE.SESSION_ID
, 'TAXABILITY') "TAX_TYPE_NAME"
FROM BEN_APLCN_TO_BNFT_POOL_F ABP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ABP.EFFECTIVE_START_DATE
AND ABP.EFFECTIVE_END_DATE