View: BENBV_BNFT_PRVDD_LDGR_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the benefit pool ledger details for a participant and a benefit provider pool.
Implementation/DBA Data:	APPS.BENBV_BNFT_PRVDD_LDGR_V

View Text

SELECT BPL.EFFECTIVE_START_DATE
, BPL.EFFECTIVE_END_DATE
, BPL.FRFTD_VAL
, BPL.PRVDD_VAL
, BPL.RLD_UP_VAL
, BPL.USED_VAL
, BPL.CASH_RECD_VAL
, BPL.CMCD_FRFTD_VAL
, BPL.CMCD_PRVDD_VAL
, BPL.CMCD_RLD_UP_VAL
, BPL.CMCD_USED_VAL
, BPL.CMCD_CASH_RECD_VAL
, BPL.ANN_FRFTD_VAL
, BPL.ANN_PRVDD_VAL
, BPL.ANN_RLD_UP_VAL
, BPL.ANN_USED_VAL
, BPL.ANN_CASH_RECD_VAL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_BNFT_PRVDD_LDGR_F:BPL'
, /* CODES */ BPL.ACTY_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, BPL.ACTY_REF_PERD_CD)
, BPL.CMCD_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, BPL.CMCD_REF_PERD_CD)
, BPL.PRTT_RO_OF_UNUSD_AMT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BPL.PRTT_RO_OF_UNUSD_AMT_FLAG)
, /* ID COLUMNS */ BPL.BNFT_PRVDD_LDGR_ID
, BPL.PER_IN_LER_ID
, BPL.ACTY_BASE_RT_ID
, BPL.BUSINESS_GROUP_ID
, BPL.BNFT_PRVDR_POOL_ID
, BPL.PRTT_ENRT_RSLT_ID
, /* WHO COLUMNS */ BPL.LAST_UPDATE_DATE
, BPL.LAST_UPDATED_BY
, BPL.CREATED_BY
, BPL.CREATION_DATE
FROM BEN_BNFT_PRVDD_LDGR_F BPL
WHERE BPL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BPL.BUSINESS_GROUP_ID) WITH READ ONLY

Columns