[Home] [Help]
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
Name |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
VAL |
"_DF:PBB" |
PER_BNFTS_BAL_ID |
BUSINESS_GROUP_ID |
BNFTS_BAL_ID |
PERSON_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |