Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ACTY_BASE_RT_D |
SELECT ABR.ROWID ROW_ID
, ABR.ACTY_BASE_RT_ID
, ABR.EFFECTIVE_START_DATE
, ABR.EFFECTIVE_END_DATE
, HR_GENERAL.DECODE_LOOKUP(ABR.ACTY_TYP_CD
, 'BEN_ACTY_TYP')
, ABR.NAME
, HR_GENERAL.DECODE_LOOKUP('BEN_RT_TYP'
, ABR.RT_TYP_CD)
, HR_GENERAL.DECODE_LOOKUP('BEN_RT_TYP'
, ABR.BNFT_RT_TYP_CD)
, HR_GENERAL.DECODE_LOOKUP('BEN_TX_TYP'
, ABR.TX_TYP_CD)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.USE_TO_CALC_NET_FLX_CR_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.ASN_ON_ENRT_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.ABV_MX_ELCN_VAL_ALWD_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.BLW_MN_ELCN_ALWD_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.DSPLY_ON_ENRT_FLAG)
, HR_GENERAL.DECODE_LOOKUP('BEN_PRNT_CHLD'
, ABR.PARNT_CHLD_CD)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.USE_CALC_ACTY_BS_RT_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.USES_DED_SCHED_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.USES_VARBL_RT_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.VSTG_SCHED_APLS_FLAG)
, HR_GENERAL.DECODE_LOOKUP('BEN_MLT'
, ABR.RT_MLT_CD)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.PROC_EACH_PP_DFLT_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.PRDCT_FLX_CR_WHEN_ELIG_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ABR.NO_STD_RT_USED_FLAG)
, HR_GENERAL.DECODE_LOOKUP('BEN_RCRRG'
, ABR.RCRRG_CD)
, HR_GENERAL.DECODE_LOOKUP('BEN_ALWS_CHG'
, ABR.ALWS_CHG_CD)
, HR_GENERAL.DECODE_LOOKUP('BEN_ELE_ENTRY_VAL'
, ABR.ELE_ENTRY_VAL_CD)
, ABR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, ABR.PAY_RATE_GRADE_RULE_ID
FROM BEN_ACTY_BASE_RT_F ABR
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= ABR.LAST_UPDATED_BY