View: BENBV_PER_BNFTS_BAL_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the value of a benefits balance for a person.
Implementation/DBA Data:	APPS.BENBV_PER_BNFTS_BAL_V

View Text

SELECT PBB.EFFECTIVE_START_DATE
, PBB.EFFECTIVE_END_DATE
, PBB.VAL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_BNFTS_BAL_F:PBB'
, /* ID COLUMNS */ PBB.PER_BNFTS_BAL_ID
, PBB.BUSINESS_GROUP_ID
, PBB.BNFTS_BAL_ID
, PBB.PERSON_ID
, /* WHO COLUMNS */ PBB.LAST_UPDATE_DATE
, PBB.LAST_UPDATED_BY
, PBB.CREATED_BY
, PBB.CREATION_DATE
FROM BEN_PER_BNFTS_BAL_F PBB
WHERE PBB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBB.BUSINESS_GROUP_ID) WITH READ ONLY

Columns