Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies balance type information which is not readily derivable from information contained in the system or which may be provided by a third party agent. |
Implementation/DBA Data: | APPS.BENBV_BNFTS_BAL_V |
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