VIEW: APPS.BEN_ACTY_BASE_RT_D

Source

View Text - Preformatted

SELECT abr.ROWID row_id, abr.acty_base_rt_id, abr.effective_start_date, abr.effective_end_date, hr_general.decode_lookup ('BEN_ACTY_TYP', abr.acty_typ_cd), 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.user_name, abr.pay_rate_grade_rule_id, abr.currency_det_cd, abr.element_det_rl FROM ben_acty_base_rt_f abr, fnd_user fuser WHERE FUSER.USER_ID (+)= ABR.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT ABR.ROWID ROW_ID
, ABR.ACTY_BASE_RT_ID
, ABR.EFFECTIVE_START_DATE
, ABR.EFFECTIVE_END_DATE
, HR_GENERAL.DECODE_LOOKUP ('BEN_ACTY_TYP'
, ABR.ACTY_TYP_CD)
, 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.USER_NAME
, ABR.PAY_RATE_GRADE_RULE_ID
, ABR.CURRENCY_DET_CD
, ABR.ELEMENT_DET_RL
FROM BEN_ACTY_BASE_RT_F ABR
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= ABR.LAST_UPDATED_BY