VIEW: APPS.BENBV_PRTL_MO_RT_PRTN_VAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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