Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PRTL_MO_RT_PRTN_VAL_X |
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