VIEW: APPS.BEN_BNFT_PRVDD_LDGR_D

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'