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