[Home] [Help]
View: BEN_BNFTS_BAL_D
Product: | BEN - Advanced Benefits |
Description: | - Retrofitted - Retrofitted |
Implementation/DBA Data: |
APPS.BEN_BNFTS_BAL_D
|
View Text
SELECT BNB.ROWID ROW_ID
, BNB.BNFTS_BAL_ID
, BNB.EFFECTIVE_START_DATE
, BNB.EFFECTIVE_END_DATE
, BNB.NAME
, BNFTS_BAL_USG.MEANING
, BNB.BNFTS_BAL_DESC
, CURRENCY.NAME
, NNMNTRY_UOM.MEANING
, BNB.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_BNFTS_BAL_F BNB
, FND_USER FUSER
, HR_LOOKUPS BNFTS_BAL_USG
, HR_LOOKUPS NNMNTRY_UOM
, FND_CURRENCIES_TL CURRENCY
WHERE FUSER.USER_ID (+)= BNB.LAST_UPDATED_BY
AND BNFTS_BAL_USG.LOOKUP_CODE (+)= BNB.BNFTS_BAL_USG_CD
AND BNFTS_BAL_USG.LOOKUP_TYPE (+)= 'BEN_BNFTS_BAL_USG'
AND NNMNTRY_UOM.LOOKUP_CODE (+)= BNB.NNMNTRY_UOM
AND NNMNTRY_UOM.LOOKUP_TYPE (+)= 'BEN_NNMNTRY_UOM'
AND CURRENCY.CURRENCY_CODE(+) = BNB.UOM
Columns
Name |
ROW_ID |
BNFTS_BAL_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
NAME |
BNFTS_BAL_USG_MEANING |
BNFTS_BAL_DESC |
UOM_NAME |
NNMNTRY_UOM_MEANING |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |