View: BEN_BNFT_PRVDD_LDGR_D

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

View Text

SELECT BPL.ROWID ROW_ID
, BPL.BNFT_PRVDD_LDGR_ID
, BPL.EFFECTIVE_START_DATE
, BPL.EFFECTIVE_END_DATE
, PRTT_RO_OF_UNUSD_AMT.MEANING
, BPL.PRVDD_VAL
, BPL.USED_VAL
, ACTY_REF_PERD.MEANING
, BPL.CMCD_FRFTD_VAL
, BPL.CMCD_PRVDD_VAL
, BPL.CMCD_RLD_UP_VAL
, BPL.CMCD_USED_VAL
, BPL.CMCD_CASH_RECD_VAL
, CMCD_REF_PERD.MEANING
, BPL.ANN_FRFTD_VAL
, BPL.ANN_PRVDD_VAL
, BPL.ANN_RLD_UP_VAL
, BPL.ANN_USED_VAL
, BPL.ANN_CASH_RECD_VAL
, BNFT_PRVDR_POOL.NAME
, ACTY_BASE_RT.NAME
, BPL.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_BNFT_PRVDD_LDGR_F BPL
, FND_USER FUSER
, BEN_BNFT_PRVDR_POOL_F BNFT_PRVDR_POOL
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, HR_LOOKUPS PRTT_RO_OF_UNUSD_AMT
, HR_LOOKUPS ACTY_REF_PERD
, HR_LOOKUPS CMCD_REF_PERD
WHERE FUSER.USER_ID (+)= BPL.LAST_UPDATED_BY
AND BNFT_PRVDR_POOL.BNFT_PRVDR_POOL_ID (+)= BPL.BNFT_PRVDR_POOL_ID
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= BPL.ACTY_BASE_RT_ID
AND PRTT_RO_OF_UNUSD_AMT.LOOKUP_CODE (+)= BPL.PRTT_RO_OF_UNUSD_AMT_FLAG
AND PRTT_RO_OF_UNUSD_AMT.LOOKUP_TYPE (+)= 'YES_NO'
AND ACTY_REF_PERD.LOOKUP_CODE (+)= BPL.ACTY_REF_PERD_CD
AND ACTY_REF_PERD.LOOKUP_TYPE (+)= 'BEN_ACTY_REF_PERD'
AND CMCD_REF_PERD.LOOKUP_CODE (+)= BPL. CMCD_REF_PERD_CD
AND CMCD_REF_PERD.LOOKUP_TYPE (+)= 'BEN_CMCD_REF_PERD'

Columns