VIEW: APPS.BEN_BNFTS_BAL_D

Source

View Text - Preformatted

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 AND currency.language = userenv('lang')

View Text - HTML Formatted

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
AND CURRENCY.LANGUAGE = USERENV('LANG')