Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies how to prorate rates when a participant's enrollment coverage date falls within a month and the plan requires that rates be prorated. |
Implementation/DBA Data: | APPS.BENBV_PRTL_MO_RT_PRTN_VAL_V |
SELECT PMR.EFFECTIVE_END_DATE
, PMR.EFFECTIVE_START_DATE
, PMR.TO_DY_MO_NUM
, PMR.FROM_DY_MO_NUM
, PMR.PCT_VAL
, PMR.RNDG_RL
, PMR.PRTL_MO_PRORTN_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTL_MO_RT_PRTN_VAL_F:PMR'
, /* CODES */ PMR.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, PMR.RNDG_CD)
, PMR.STRT_R_STP_CVG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STRT_R_STP_CVG'
, PMR.STRT_R_STP_CVG_CD)
, /* ID COLUMNS */ PMR.PRTL_MO_RT_PRTN_VAL_ID
, PMR.BUSINESS_GROUP_ID
, PMR.ACTL_PREM_ID
, PMR.CVG_AMT_CALC_MTHD_ID
, PMR.ACTY_BASE_RT_ID
, /* WHO COLUMNS */ PMR.LAST_UPDATE_DATE
, PMR.LAST_UPDATED_BY
, PMR.CREATED_BY
, PMR.CREATION_DATE
FROM BEN_PRTL_MO_RT_PRTN_VAL_F PMR
WHERE PMR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PMR.BUSINESS_GROUP_ID) WITH READ ONLY