View: BEN_POE_RT_D

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

View Text

SELECT PRT.POE_RT_ID
, PRT.EFFECTIVE_START_DATE
, PRT.EFFECTIVE_END_DATE
, PRT.MN_POE_NUM
, PRT.MX_POE_NUM
, PRT.NO_MN_POE_FLAG
, PRT.NO_MX_POE_FLAG
, RNDG.MEANING
, PRT.RNDG_RL
, UOM.MEANING
, VPR.NAME
, PRT.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_POE_RT_F PRT
, FND_USER FUSER
, HR_LOOKUPS UOM
, HR_LOOKUPS RNDG
, BEN_VRBL_RT_PRFL_F VPR
WHERE FUSER.USER_ID (+) = PRT.LAST_UPDATED_BY
AND UOM.LOOKUP_TYPE = 'BEN_RQD_PERD_ENRT_NENRT_TM_UOM'
AND UOM.LOOKUP_CODE = PRT.POE_NNMNTRY_UOM
AND RNDG.LOOKUP_TYPE (+)= 'BEN_RNDG'
AND RNDG.LOOKUP_CODE (+)= PRT.RNDG_CD
AND PRT.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID

Columns