View: BEN_PER_BNFTS_BAL_D

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_PER_BNFTS_BAL_D

View Text

SELECT PBB.ROWID ROW_ID
, PBB.PER_BNFTS_BAL_ID
, PBB.EFFECTIVE_START_DATE
, PBB.EFFECTIVE_END_DATE
, PBB.VAL
, BNFTS_BAL.NAME
, PERSON.FULL_NAME
, PBB.LAST_UPDATE_DATE
, PBB.LAST_UPDATED_BY
FROM BEN_PER_BNFTS_BAL_F PBB
, FND_USER FUSER
, BEN_BNFTS_BAL_F BNFTS_BAL
, PER_ALL_PEOPLE_F PERSON
WHERE FUSER.USER_ID (+)= PBB .LAST_UPDATED_BY
AND BNFTS_BAL.BNFTS_BAL_ID (+)= PBB .BNFTS_BAL_ID
AND PERSON.PERSON_ID = PBB .PERSON_ID
AND PBB.EFFECTIVE_START_DATE BETWEEN PERSON.EFFECTIVE_START_DATE
AND PERSON.EFFECTIVE_END_DATE

Columns