VIEW: APPS.BEN_POE_RT_D

Source

View Text - Preformatted

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 AND prt.effective_start_date between vpr.effective_start_date(+) and vpr.effective_end_date(+)

View Text - HTML Formatted

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
AND PRT.EFFECTIVE_START_DATE BETWEEN VPR.EFFECTIVE_START_DATE(+)
AND VPR.EFFECTIVE_END_DATE(+)