eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BENBV_ELIG_PER_V

Source

View Text - Preformatted


SELECT PEP.EFFECTIVE_START_DATE, PEP.EFFECTIVE_END_DATE, PEP.PL_ORDR_NUM, PEP.PLIP_ORDR_NUM, PEP.PTIP_ORDR_NUM, PEP.PROGRAM_UPDATE_DATE, PEP.CMBN_AGE_N_LOS_VAL, PEP.OVRID_SVC_DT, PEP.COMP_REF_AMT, PEP.AGE_VAL, PEP.LOS_VAL, PEP.PRTN_END_DT, PEP.HRS_WKD_VAL, PEP.PRTN_OVRIDN_THRU_DT, PEP.PCT_FL_TM_VAL, PEP.PRTN_STRT_DT, PEP.AGE_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',PEP.AGE_UOM), PEP.LOS_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',PEP.LOS_UOM), PEP.COMP_REF_UOM, PEP.RT_COMP_REF_AMT, PEP.RT_CMBN_AGE_N_LOS_VAL, PEP.RT_COMP_REF_UOM, PEP.RT_AGE_VAL, PEP.RT_LOS_VAL, PEP.RT_HRS_WKD_VAL, PEP.RT_AGE_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',PEP.RT_AGE_UOM), PEP.RT_LOS_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',PEP.RT_LOS_UOM), PEP.RT_PCT_FL_TM_VAL, PEP.WAIT_PERD_CMPLTN_DT, PEP.WAIT_PERD_STRT_DT, /* descriptive flexfield */ '_DF:BEN:BEN_ELIG_PER_F:PEP', /* codes */ PEP.HRS_WKD_BNDRY_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD',PEP.HRS_WKD_BNDRY_PERD_CD), PEP.WV_PRTN_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_WV_PRTN_RSN',PEP.WV_PRTN_RSN_CD), PEP.PRTN_OVRIDN_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_OVRRIDN_RSN',PEP.PRTN_OVRIDN_RSN_CD), PEP.WV_CTFN_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_WV_PRTN_CTFN_TYP',PEP.WV_CTFN_TYP_CD), PEP.RT_HRS_WKD_BNDRY_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD',PEP.RT_HRS_WKD_BNDRY_PERD_CD), PEP.INELG_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_INELG_RSN',PEP.INELG_RSN_CD), PEP.ONCE_R_CNTUG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONCE_R_CNTNG',PEP.ONCE_R_CNTUG_CD), PEP.DSTR_RSTCN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.DSTR_RSTCN_FLAG), PEP.DPNT_OTHR_PL_CVRD_RL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.DPNT_OTHR_PL_CVRD_RL_FLAG), PEP.PL_HGHLY_COMPD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.PL_HGHLY_COMPD_FLAG), PEP.PL_KEY_EE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.PL_KEY_EE_FLAG), PEP.ELIG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.ELIG_FLAG), PEP.PL_WVD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.PL_WVD_FLAG), PEP.PRTN_OVRIDN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.PRTN_OVRIDN_FLAG), PEP.NO_MX_PRTN_OVRID_THRU_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.NO_MX_PRTN_OVRID_THRU_FLAG), PEP.FRZ_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.FRZ_LOS_FLAG), PEP.FRZ_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.FRZ_AGE_FLAG), PEP.FRZ_CMP_LVL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.FRZ_CMP_LVL_FLAG), PEP.FRZ_PCT_FL_TM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.FRZ_PCT_FL_TM_FLAG), PEP.FRZ_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.FRZ_HRS_WKD_FLAG), PEP.FRZ_COMB_AGE_AND_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.FRZ_COMB_AGE_AND_LOS_FLAG), PEP.RT_FRZ_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.RT_FRZ_LOS_FLAG), PEP.RT_FRZ_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.RT_FRZ_AGE_FLAG), PEP.RT_FRZ_CMP_LVL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.RT_FRZ_CMP_LVL_FLAG), PEP.RT_FRZ_PCT_FL_TM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.RT_FRZ_PCT_FL_TM_FLAG), PEP.RT_FRZ_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.RT_FRZ_HRS_WKD_FLAG), PEP.RT_FRZ_COMB_AGE_AND_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEP.RT_FRZ_COMB_AGE_AND_LOS_FLAG), /* id columns */ PEP.ELIG_PER_ID, PEP.PERSON_ID, PEP.BUSINESS_GROUP_ID, PEP.REQUEST_ID, PEP.PROGRAM_APPLICATION_ID, PEP.PROGRAM_ID, PEP.PER_IN_LER_ID, PEP.PL_ID, PEP.PLIP_ID, PEP.PGM_ID, PEP.PTIP_ID, PEP.LER_ID, PEP.MUST_ENRL_ANTHR_PL_ID, /* who columns */ PEP.LAST_UPDATE_DATE, PEP.LAST_UPDATED_BY, PEP.CREATED_BY, PEP.CREATION_DATE FROM BEN_ELIG_PER_F PEP WHERE PEP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PEP.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PEP.EFFECTIVE_START_DATE
, PEP.EFFECTIVE_END_DATE
, PEP.PL_ORDR_NUM
, PEP.PLIP_ORDR_NUM
, PEP.PTIP_ORDR_NUM
, PEP.PROGRAM_UPDATE_DATE
, PEP.CMBN_AGE_N_LOS_VAL
, PEP.OVRID_SVC_DT
, PEP.COMP_REF_AMT
, PEP.AGE_VAL
, PEP.LOS_VAL
, PEP.PRTN_END_DT
, PEP.HRS_WKD_VAL
, PEP.PRTN_OVRIDN_THRU_DT
, PEP.PCT_FL_TM_VAL
, PEP.PRTN_STRT_DT
, PEP.AGE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, PEP.AGE_UOM)
, PEP.LOS_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, PEP.LOS_UOM)
, PEP.COMP_REF_UOM
, PEP.RT_COMP_REF_AMT
, PEP.RT_CMBN_AGE_N_LOS_VAL
, PEP.RT_COMP_REF_UOM
, PEP.RT_AGE_VAL
, PEP.RT_LOS_VAL
, PEP.RT_HRS_WKD_VAL
, PEP.RT_AGE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, PEP.RT_AGE_UOM)
, PEP.RT_LOS_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, PEP.RT_LOS_UOM)
, PEP.RT_PCT_FL_TM_VAL
, PEP.WAIT_PERD_CMPLTN_DT
, PEP.WAIT_PERD_STRT_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_PER_F:PEP'
, /* CODES */ PEP.HRS_WKD_BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD'
, PEP.HRS_WKD_BNDRY_PERD_CD)
, PEP.WV_PRTN_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WV_PRTN_RSN'
, PEP.WV_PRTN_RSN_CD)
, PEP.PRTN_OVRIDN_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_OVRRIDN_RSN'
, PEP.PRTN_OVRIDN_RSN_CD)
, PEP.WV_CTFN_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WV_PRTN_CTFN_TYP'
, PEP.WV_CTFN_TYP_CD)
, PEP.RT_HRS_WKD_BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD'
, PEP.RT_HRS_WKD_BNDRY_PERD_CD)
, PEP.INELG_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_INELG_RSN'
, PEP.INELG_RSN_CD)
, PEP.ONCE_R_CNTUG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONCE_R_CNTNG'
, PEP.ONCE_R_CNTUG_CD)
, PEP.DSTR_RSTCN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.DSTR_RSTCN_FLAG)
, PEP.DPNT_OTHR_PL_CVRD_RL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.DPNT_OTHR_PL_CVRD_RL_FLAG)
, PEP.PL_HGHLY_COMPD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.PL_HGHLY_COMPD_FLAG)
, PEP.PL_KEY_EE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.PL_KEY_EE_FLAG)
, PEP.ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.ELIG_FLAG)
, PEP.PL_WVD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.PL_WVD_FLAG)
, PEP.PRTN_OVRIDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.PRTN_OVRIDN_FLAG)
, PEP.NO_MX_PRTN_OVRID_THRU_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.NO_MX_PRTN_OVRID_THRU_FLAG)
, PEP.FRZ_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.FRZ_LOS_FLAG)
, PEP.FRZ_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.FRZ_AGE_FLAG)
, PEP.FRZ_CMP_LVL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.FRZ_CMP_LVL_FLAG)
, PEP.FRZ_PCT_FL_TM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.FRZ_PCT_FL_TM_FLAG)
, PEP.FRZ_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.FRZ_HRS_WKD_FLAG)
, PEP.FRZ_COMB_AGE_AND_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.FRZ_COMB_AGE_AND_LOS_FLAG)
, PEP.RT_FRZ_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.RT_FRZ_LOS_FLAG)
, PEP.RT_FRZ_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.RT_FRZ_AGE_FLAG)
, PEP.RT_FRZ_CMP_LVL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.RT_FRZ_CMP_LVL_FLAG)
, PEP.RT_FRZ_PCT_FL_TM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.RT_FRZ_PCT_FL_TM_FLAG)
, PEP.RT_FRZ_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.RT_FRZ_HRS_WKD_FLAG)
, PEP.RT_FRZ_COMB_AGE_AND_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEP.RT_FRZ_COMB_AGE_AND_LOS_FLAG)
, /* ID COLUMNS */ PEP.ELIG_PER_ID
, PEP.PERSON_ID
, PEP.BUSINESS_GROUP_ID
, PEP.REQUEST_ID
, PEP.PROGRAM_APPLICATION_ID
, PEP.PROGRAM_ID
, PEP.PER_IN_LER_ID
, PEP.PL_ID
, PEP.PLIP_ID
, PEP.PGM_ID
, PEP.PTIP_ID
, PEP.LER_ID
, PEP.MUST_ENRL_ANTHR_PL_ID
, /* WHO COLUMNS */ PEP.LAST_UPDATE_DATE
, PEP.LAST_UPDATED_BY
, PEP.CREATED_BY
, PEP.CREATION_DATE
FROM BEN_ELIG_PER_F PEP
WHERE PEP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEP.BUSINESS_GROUP_ID) WITH READ ONLY