VIEW: APPS.BENBV_BNFTS_BAL_V

Source

View Text - Preformatted

SELECT BNB.EFFECTIVE_START_DATE, BNB.EFFECTIVE_END_DATE, BNB.BNFTS_BAL_DESC, BNB.UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM',BNB.UOM), BNB.NNMNTRY_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM',BNB.NNMNTRY_UOM), BNB.NAME, /* descriptive flexfield */ '_DF:BEN:BEN_BNFTS_BAL_F:BNB', /* codes */ BNB.BNFTS_BAL_USG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFTS_BAL_USG',BNB.BNFTS_BAL_USG_CD), /* id columns */ BNB.BNFTS_BAL_ID, BNB.BUSINESS_GROUP_ID, /* who columns */ BNB.LAST_UPDATE_DATE, BNB.LAST_UPDATED_BY, BNB.CREATED_BY, BNB.CREATION_DATE FROM BEN_BNFTS_BAL_F BNB WHERE BNB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, BNB.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT BNB.EFFECTIVE_START_DATE
, BNB.EFFECTIVE_END_DATE
, BNB.BNFTS_BAL_DESC
, BNB.UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, BNB.UOM)
, BNB.NNMNTRY_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, BNB.NNMNTRY_UOM)
, BNB.NAME
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_BNFTS_BAL_F:BNB'
, /* CODES */ BNB.BNFTS_BAL_USG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFTS_BAL_USG'
, BNB.BNFTS_BAL_USG_CD)
, /* ID COLUMNS */ BNB.BNFTS_BAL_ID
, BNB.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ BNB.LAST_UPDATE_DATE
, BNB.LAST_UPDATED_BY
, BNB.CREATED_BY
, BNB.CREATION_DATE
FROM BEN_BNFTS_BAL_F BNB
WHERE BNB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BNB.BUSINESS_GROUP_ID) WITH READ ONLY