VIEW: APPS.BEN_PRTL_MO_RT_PRTN_VAL_D

Source

View Text - Preformatted

SELECT ppv.ROWID row_id, ppv.prtl_mo_rt_prtn_val_id, ppv.effective_end_date, ppv.effective_start_date, acty_base_rt.NAME, rndg_rl.formula_name, rndg.meaning, ppv.to_dy_mo_num, ppv.from_dy_mo_num, ppv.pct_val, ppv.last_update_date, fuser.user_name, apr.NAME, ppv.num_days_month, hr_general.decode_lookup ('YES_NO', ppv.prorate_by_day_to_mon_flag), prtl_mo_prortn.formula_name, hr_general.decode_lookup ('BEN_STRT_R_STP_CVG', ppv.strt_r_stp_cvg_cd ), ccm.NAME FROM ben_prtl_mo_rt_prtn_val_f ppv, fnd_user fuser, ben_acty_base_rt_f acty_base_rt, hr_lookups rndg, ff_formulas_f rndg_rl, ff_formulas_f prtl_mo_prortn, ben_actl_prem_f apr, ben_cvg_amt_calc_mthd_f ccm WHERE fuser.user_id(+) = ppv.last_updated_by AND acty_base_rt.acty_base_rt_id(+) = ppv.acty_base_rt_id AND rndg.lookup_code(+) = ppv.rndg_cd AND rndg.lookup_type(+) = 'BEN_RNDG' AND rndg_rl.formula_id(+) = ppv.rndg_rl AND ppv.effective_start_date BETWEEN rndg_rl.effective_start_date(+) AND rndg_rl.effective_end_date(+) AND ppv.actl_prem_id = apr.actl_prem_id(+) AND ppv.effective_start_date BETWEEN apr.effective_start_date(+) AND apr.effective_end_date(+) AND ppv.cvg_amt_calc_mthd_id = ccm.cvg_amt_calc_mthd_id(+) AND ppv.effective_start_date BETWEEN ccm.effective_start_date(+) AND ccm.effective_end_date(+) AND ppv.prtl_mo_prortn_rl = prtl_mo_prortn.formula_id(+) AND ppv.effective_start_date BETWEEN prtl_mo_prortn.effective_start_date(+) AND prtl_mo_prortn.effective_end_date(+)

View Text - HTML Formatted

SELECT PPV.ROWID ROW_ID
, PPV.PRTL_MO_RT_PRTN_VAL_ID
, PPV.EFFECTIVE_END_DATE
, PPV.EFFECTIVE_START_DATE
, ACTY_BASE_RT.NAME
, RNDG_RL.FORMULA_NAME
, RNDG.MEANING
, PPV.TO_DY_MO_NUM
, PPV.FROM_DY_MO_NUM
, PPV.PCT_VAL
, PPV.LAST_UPDATE_DATE
, FUSER.USER_NAME
, APR.NAME
, PPV.NUM_DAYS_MONTH
, HR_GENERAL.DECODE_LOOKUP ('YES_NO'
, PPV.PRORATE_BY_DAY_TO_MON_FLAG)
, PRTL_MO_PRORTN.FORMULA_NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_STRT_R_STP_CVG'
, PPV.STRT_R_STP_CVG_CD )
, CCM.NAME
FROM BEN_PRTL_MO_RT_PRTN_VAL_F PPV
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, HR_LOOKUPS RNDG
, FF_FORMULAS_F RNDG_RL
, FF_FORMULAS_F PRTL_MO_PRORTN
, BEN_ACTL_PREM_F APR
, BEN_CVG_AMT_CALC_MTHD_F CCM
WHERE FUSER.USER_ID(+) = PPV.LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID(+) = PPV.ACTY_BASE_RT_ID
AND RNDG.LOOKUP_CODE(+) = PPV.RNDG_CD
AND RNDG.LOOKUP_TYPE(+) = 'BEN_RNDG'
AND RNDG_RL.FORMULA_ID(+) = PPV.RNDG_RL
AND PPV.EFFECTIVE_START_DATE BETWEEN RNDG_RL.EFFECTIVE_START_DATE(+)
AND RNDG_RL.EFFECTIVE_END_DATE(+)
AND PPV.ACTL_PREM_ID = APR.ACTL_PREM_ID(+)
AND PPV.EFFECTIVE_START_DATE BETWEEN APR.EFFECTIVE_START_DATE(+)
AND APR.EFFECTIVE_END_DATE(+)
AND PPV.CVG_AMT_CALC_MTHD_ID = CCM.CVG_AMT_CALC_MTHD_ID(+)
AND PPV.EFFECTIVE_START_DATE BETWEEN CCM.EFFECTIVE_START_DATE(+)
AND CCM.EFFECTIVE_END_DATE(+)
AND PPV.PRTL_MO_PRORTN_RL = PRTL_MO_PRORTN.FORMULA_ID(+)
AND PPV.EFFECTIVE_START_DATE BETWEEN PRTL_MO_PRORTN.EFFECTIVE_START_DATE(+)
AND PRTL_MO_PRORTN.EFFECTIVE_END_DATE(+)