View: BEN_VRBL_RT_ELIG_PRFL_D

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

View Text

SELECT VEP.VRBL_RT_ELIG_PRFL_ID
, VEP.EFFECTIVE_START_DATE
, VEP.EFFECTIVE_END_DATE
, VRP.NAME
, BEP.NAME
, VEP.LAST_UPDATE_DATE
, HL1.MEANING
, FUSER.USER_NAME
FROM BEN_VRBL_RT_ELIG_PRFL_F VEP
, BEN_VRBL_RT_PRFL_F VRP
, BEN_ELIGY_PRFL_F BEP
, HR_LOOKUPS HL1
, FND_USER FUSER
WHERE HL1.LOOKUP_CODE (+) = VEP.MNDTRY_FLAG
AND HL1.LOOKUP_TYPE (+) = 'YES_NO'
AND VEP.VRBL_RT_PRFL_ID = VRP.VRBL_RT_PRFL_ID
AND VEP.BUSINESS_GROUP_ID = VRP.BUSINESS_GROUP_ID
AND VEP.EFFECTIVE_START_DATE BETWEEN VRP.EFFECTIVE_START_DATE
AND VRP.EFFECTIVE_END_DATE
AND VEP.ELIGY_PRFL_ID = BEP.ELIGY_PRFL_ID
AND VEP.BUSINESS_GROUP_ID = BEP.BUSINESS_GROUP_ID
AND VEP.EFFECTIVE_START_DATE BETWEEN BEP.EFFECTIVE_START_DATE
AND BEP.EFFECTIVE_END_DATE
AND FUSER.USER_ID (+) = VEP.LAST_UPDATED_BY

Columns