VIEW: APPS.BEN_VRBL_RT_ELIG_PRFL_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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