[Home] [Help]
View: BEN_APLCN_TO_BNFT_POOL_D
View Text
SELECT ABP.ROWID ROW_ID
, ABP.APLCN_TO_BNFT_POOL_ID
, ABP.EFFECTIVE_START_DATE
, ABP.EFFECTIVE_END_DATE
, ACTY_BASE_RT.NAME
, BNFT_PRVDR_POOL.NAME
, ABP.LAST_UPDATE_DATE
, ABP.LAST_UPDATED_BY
FROM BEN_APLCN_TO_BNFT_POOL_F ABP
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_BNFT_PRVDR_POOL_F BNFT_PRVDR_POOL
WHERE FUSER.USER_ID (+)= ABP .LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= ABP .ACTY_BASE_RT_ID
AND BNFT_PRVDR_POOL.BNFT_PRVDR_POOL_ID (+)= ABP .BNFT_PRVDR_POOL_ID
Columns
Name |
ROW_ID |
APLCN_TO_BNFT_POOL_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
ACTY_BASE_RT_NAME |
BNFT_PRVDR_POOL_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |