VIEW: APPS.BEN_PRTL_MO_RT_PRTN_VAL_X

Source

View Text - Preformatted

SELECT ppv.PRTL_MO_RT_PRTN_VAL_ID ,ppv.EFFECTIVE_END_DATE ,ppv.EFFECTIVE_START_DATE ,ppv.BUSINESS_GROUP_ID ,ppv.RNDG_CD ,ppv.TO_DY_MO_NUM ,ppv.FROM_DY_MO_NUM ,ppv.PCT_VAL ,ppv.ACTY_BASE_RT_ID ,ppv.STRT_R_STP_CVG_CD ,ppv.RNDG_RL ,ppv.PRTL_MO_PRORTN_RL ,ppv.ACTL_PREM_ID ,ppv.CVG_AMT_CALC_MTHD_ID ,ppv.num_days_month ,ppv.prorate_by_day_to_mon_flag ,ppv.PMRPV_ATTRIBUTE_CATEGORY ,ppv.PMRPV_ATTRIBUTE1 ,ppv.PMRPV_ATTRIBUTE2 ,ppv.PMRPV_ATTRIBUTE3 ,ppv.PMRPV_ATTRIBUTE4 ,ppv.PMRPV_ATTRIBUTE5 ,ppv.PMRPV_ATTRIBUTE6 ,ppv.PMRPV_ATTRIBUTE7 ,ppv.PMRPV_ATTRIBUTE8 ,ppv.PMRPV_ATTRIBUTE9 ,ppv.PMRPV_ATTRIBUTE10 ,ppv.PMRPV_ATTRIBUTE11 ,ppv.PMRPV_ATTRIBUTE12 ,ppv.PMRPV_ATTRIBUTE13 ,ppv.PMRPV_ATTRIBUTE14 ,ppv.PMRPV_ATTRIBUTE15 ,ppv.PMRPV_ATTRIBUTE16 ,ppv.PMRPV_ATTRIBUTE17 ,ppv.PMRPV_ATTRIBUTE18 ,ppv.PMRPV_ATTRIBUTE19 ,ppv.PMRPV_ATTRIBUTE20 ,ppv.PMRPV_ATTRIBUTE21 ,ppv.PMRPV_ATTRIBUTE22 ,ppv.PMRPV_ATTRIBUTE23 ,ppv.PMRPV_ATTRIBUTE24 ,ppv.PMRPV_ATTRIBUTE25 ,ppv.PMRPV_ATTRIBUTE26 ,ppv.PMRPV_ATTRIBUTE27 ,ppv.PMRPV_ATTRIBUTE28 ,ppv.PMRPV_ATTRIBUTE29 ,ppv.PMRPV_ATTRIBUTE30 ,ppv.LAST_UPDATE_DATE ,ppv.LAST_UPDATED_BY ,ppv.LAST_UPDATE_LOGIN ,ppv.CREATED_BY ,ppv.CREATION_DATE ,ppv.OBJECT_VERSION_NUMBER from BEN_PRTL_MO_RT_PRTN_VAL_F ppv WHERE trunc(sysdate) between ppv.effective_start_date and ppv.effective_end_date

View Text - HTML Formatted

SELECT PPV.PRTL_MO_RT_PRTN_VAL_ID
, PPV.EFFECTIVE_END_DATE
, PPV.EFFECTIVE_START_DATE
, PPV.BUSINESS_GROUP_ID
, PPV.RNDG_CD
, PPV.TO_DY_MO_NUM
, PPV.FROM_DY_MO_NUM
, PPV.PCT_VAL
, PPV.ACTY_BASE_RT_ID
, PPV.STRT_R_STP_CVG_CD
, PPV.RNDG_RL
, PPV.PRTL_MO_PRORTN_RL
, PPV.ACTL_PREM_ID
, PPV.CVG_AMT_CALC_MTHD_ID
, PPV.NUM_DAYS_MONTH
, PPV.PRORATE_BY_DAY_TO_MON_FLAG
, PPV.PMRPV_ATTRIBUTE_CATEGORY
, PPV.PMRPV_ATTRIBUTE1
, PPV.PMRPV_ATTRIBUTE2
, PPV.PMRPV_ATTRIBUTE3
, PPV.PMRPV_ATTRIBUTE4
, PPV.PMRPV_ATTRIBUTE5
, PPV.PMRPV_ATTRIBUTE6
, PPV.PMRPV_ATTRIBUTE7
, PPV.PMRPV_ATTRIBUTE8
, PPV.PMRPV_ATTRIBUTE9
, PPV.PMRPV_ATTRIBUTE10
, PPV.PMRPV_ATTRIBUTE11
, PPV.PMRPV_ATTRIBUTE12
, PPV.PMRPV_ATTRIBUTE13
, PPV.PMRPV_ATTRIBUTE14
, PPV.PMRPV_ATTRIBUTE15
, PPV.PMRPV_ATTRIBUTE16
, PPV.PMRPV_ATTRIBUTE17
, PPV.PMRPV_ATTRIBUTE18
, PPV.PMRPV_ATTRIBUTE19
, PPV.PMRPV_ATTRIBUTE20
, PPV.PMRPV_ATTRIBUTE21
, PPV.PMRPV_ATTRIBUTE22
, PPV.PMRPV_ATTRIBUTE23
, PPV.PMRPV_ATTRIBUTE24
, PPV.PMRPV_ATTRIBUTE25
, PPV.PMRPV_ATTRIBUTE26
, PPV.PMRPV_ATTRIBUTE27
, PPV.PMRPV_ATTRIBUTE28
, PPV.PMRPV_ATTRIBUTE29
, PPV.PMRPV_ATTRIBUTE30
, PPV.LAST_UPDATE_DATE
, PPV.LAST_UPDATED_BY
, PPV.LAST_UPDATE_LOGIN
, PPV.CREATED_BY
, PPV.CREATION_DATE
, PPV.OBJECT_VERSION_NUMBER
FROM BEN_PRTL_MO_RT_PRTN_VAL_F PPV
WHERE TRUNC(SYSDATE) BETWEEN PPV.EFFECTIVE_START_DATE
AND PPV.EFFECTIVE_END_DATE