SELECT PL_BNF_CTFN_PRVDD.PL_BNF_CTFN_PRVDD_ID , PL_BNF_CTFN_PRVDD.EFFECTIVE_START_DATE , PL_BNF_CTFN_PRVDD.EFFECTIVE_END_DATE , BNF_CTFN_TYP.MEANING BNF_CTFN_TYP_MEANING , PL_BNF_CTFN_PRVDD.BNF_CTFN_RECD_DT , BNF_CTFN_RQD.MEANING BNF_CTFN_RQD_MEANING , PL_BNF_CTFN_PRVDD.LAST_UPDATE_DATE , FUSER.USER_NAME LAST_UPDATED_BY FROM FND_USER_VIEW FUSER , BEN_PL_BNF_F PBN , BEN_PER_IN_LER PIL , BEN_PL_BNF_CTFN_PRVDD_F PL_BNF_CTFN_PRVDD , HR_LOOKUPS BNF_CTFN_TYP , HR_LOOKUPS BNF_CTFN_RQD WHERE FUSER.USER_ID (+)= PL_BNF_CTFN_PRVDD.LAST_UPDATED_BY AND BNF_CTFN_TYP.LOOKUP_CODE (+)= PL_BNF_CTFN_PRVDD.BNF_CTFN_TYP_CD AND BNF_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_BNF_CTFN_TYP' AND BNF_CTFN_RQD.LOOKUP_CODE (+)= PL_BNF_CTFN_PRVDD.BNF_CTFN_RQD_FLAG AND BNF_CTFN_RQD.LOOKUP_TYPE (+)= 'YES_NO' AND PBN.PL_BNF_ID=PL_BNF_CTFN_PRVDD.PL_BNF_ID AND PBN.BUSINESS_GROUP_ID+0=PL_BNF_CTFN_PRVDD.BUSINESS_GROUP_ID AND PL_BNF_CTFN_PRVDD.EFFECTIVE_START_DATE BETWEEN PBN.EFFECTIVE_START_DATE AND PBN.EFFECTIVE_END_DATE AND PIL.PER_IN_LER_ID(+)=PBN.PER_IN_LER_ID AND PIL.BUSINESS_GROUP_ID(+)=PBN.BUSINESS_GROUP_ID+0 AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD' , 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )