[Home] [Help]
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
Name |
POE_RT_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
MN_POE_NUM |
MX_POE_NUM |
NO_MN_POE_FLAG |
NO_MX_POE_FLAG |
RNDG_CD |
RNDG_RL |
POE_NNMNTRY_UOM |
VRBL_RT_PRFL_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |