VIEW: APPS.BENBV_ELIG_PER_OPT_V

Source

View Text - Preformatted

SELECT EPO.EFFECTIVE_START_DATE, EPO.EFFECTIVE_END_DATE, EPO.OIPL_ORDR_NUM, EPO.PROGRAM_UPDATE_DATE, EPO.PRTN_OVRIDN_THRU_DT, EPO.PCT_FL_TM_VAL, EPO.PRTN_STRT_DT, EPO.PRTN_END_DT, EPO.AGE_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',EPO.AGE_UOM), EPO.AGE_VAL, EPO.CMBN_AGE_N_LOS_VAL, EPO.COMP_REF_AMT, EPO.COMP_REF_UOM, EPO.HRS_WKD_VAL, EPO.LOS_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',EPO.LOS_UOM), EPO.LOS_VAL, EPO.RT_COMP_REF_AMT, EPO.RT_CMBN_AGE_N_LOS_VAL, EPO.RT_COMP_REF_UOM, EPO.RT_AGE_VAL, EPO.RT_LOS_VAL, EPO.RT_HRS_WKD_VAL, EPO.RT_AGE_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',EPO.RT_AGE_UOM), EPO.RT_LOS_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',EPO.RT_LOS_UOM), EPO.RT_PCT_FL_TM_VAL, EPO.OVRID_SVC_DT, EPO.WAIT_PERD_CMPLTN_DT, EPO.WAIT_PERD_STRT_DT, /* descriptive flexfield */ '_DF:BEN:BEN_ELIG_PER_OPT_F:EPO', /* codes */ EPO.HRS_WKD_BNDRY_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD',EPO.HRS_WKD_BNDRY_PERD_CD), EPO.PRTN_OVRIDN_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_OVRRIDN_RSN',EPO.PRTN_OVRIDN_RSN_CD), EPO.RT_HRS_WKD_BNDRY_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD',EPO.RT_HRS_WKD_BNDRY_PERD_CD), EPO.INELG_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_INELG_RSN',EPO.INELG_RSN_CD), EPO.ONCE_R_CNTUG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONCE_R_CNTNG',EPO.ONCE_R_CNTUG_CD), EPO.PRTN_OVRIDN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.PRTN_OVRIDN_FLAG), EPO.NO_MX_PRTN_OVRID_THRU_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.NO_MX_PRTN_OVRID_THRU_FLAG), EPO.ELIG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.ELIG_FLAG), EPO.FRZ_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.FRZ_AGE_FLAG), EPO.FRZ_CMP_LVL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.FRZ_CMP_LVL_FLAG), EPO.FRZ_COMB_AGE_AND_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.FRZ_COMB_AGE_AND_LOS_FLAG), EPO.FRZ_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.FRZ_HRS_WKD_FLAG), EPO.FRZ_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.FRZ_LOS_FLAG), EPO.FRZ_PCT_FL_TM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.FRZ_PCT_FL_TM_FLAG), EPO.RT_FRZ_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.RT_FRZ_LOS_FLAG), EPO.RT_FRZ_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.RT_FRZ_AGE_FLAG), EPO.RT_FRZ_CMP_LVL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.RT_FRZ_CMP_LVL_FLAG), EPO.RT_FRZ_PCT_FL_TM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.RT_FRZ_PCT_FL_TM_FLAG), EPO.RT_FRZ_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.RT_FRZ_HRS_WKD_FLAG), EPO.RT_FRZ_COMB_AGE_AND_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EPO.RT_FRZ_COMB_AGE_AND_LOS_FLAG), /* id columns */ EPO.ELIG_PER_OPT_ID, EPO.ELIG_PER_ID, EPO.BUSINESS_GROUP_ID, EPO.REQUEST_ID, EPO.PROGRAM_APPLICATION_ID, EPO.PROGRAM_ID, EPO.PER_IN_LER_ID, EPO.OPT_ID, /* who columns */ EPO.CREATION_DATE, EPO.CREATED_BY, EPO.LAST_UPDATE_DATE, EPO.LAST_UPDATED_BY FROM BEN_ELIG_PER_OPT_F EPO WHERE EPO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, EPO.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT EPO.EFFECTIVE_START_DATE
, EPO.EFFECTIVE_END_DATE
, EPO.OIPL_ORDR_NUM
, EPO.PROGRAM_UPDATE_DATE
, EPO.PRTN_OVRIDN_THRU_DT
, EPO.PCT_FL_TM_VAL
, EPO.PRTN_STRT_DT
, EPO.PRTN_END_DT
, EPO.AGE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, EPO.AGE_UOM)
, EPO.AGE_VAL
, EPO.CMBN_AGE_N_LOS_VAL
, EPO.COMP_REF_AMT
, EPO.COMP_REF_UOM
, EPO.HRS_WKD_VAL
, EPO.LOS_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, EPO.LOS_UOM)
, EPO.LOS_VAL
, EPO.RT_COMP_REF_AMT
, EPO.RT_CMBN_AGE_N_LOS_VAL
, EPO.RT_COMP_REF_UOM
, EPO.RT_AGE_VAL
, EPO.RT_LOS_VAL
, EPO.RT_HRS_WKD_VAL
, EPO.RT_AGE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, EPO.RT_AGE_UOM)
, EPO.RT_LOS_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, EPO.RT_LOS_UOM)
, EPO.RT_PCT_FL_TM_VAL
, EPO.OVRID_SVC_DT
, EPO.WAIT_PERD_CMPLTN_DT
, EPO.WAIT_PERD_STRT_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_PER_OPT_F:EPO'
, /* CODES */ EPO.HRS_WKD_BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD'
, EPO.HRS_WKD_BNDRY_PERD_CD)
, EPO.PRTN_OVRIDN_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_OVRRIDN_RSN'
, EPO.PRTN_OVRIDN_RSN_CD)
, EPO.RT_HRS_WKD_BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD'
, EPO.RT_HRS_WKD_BNDRY_PERD_CD)
, EPO.INELG_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_INELG_RSN'
, EPO.INELG_RSN_CD)
, EPO.ONCE_R_CNTUG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONCE_R_CNTNG'
, EPO.ONCE_R_CNTUG_CD)
, EPO.PRTN_OVRIDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.PRTN_OVRIDN_FLAG)
, EPO.NO_MX_PRTN_OVRID_THRU_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.NO_MX_PRTN_OVRID_THRU_FLAG)
, EPO.ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.ELIG_FLAG)
, EPO.FRZ_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.FRZ_AGE_FLAG)
, EPO.FRZ_CMP_LVL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.FRZ_CMP_LVL_FLAG)
, EPO.FRZ_COMB_AGE_AND_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.FRZ_COMB_AGE_AND_LOS_FLAG)
, EPO.FRZ_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.FRZ_HRS_WKD_FLAG)
, EPO.FRZ_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.FRZ_LOS_FLAG)
, EPO.FRZ_PCT_FL_TM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.FRZ_PCT_FL_TM_FLAG)
, EPO.RT_FRZ_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.RT_FRZ_LOS_FLAG)
, EPO.RT_FRZ_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.RT_FRZ_AGE_FLAG)
, EPO.RT_FRZ_CMP_LVL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.RT_FRZ_CMP_LVL_FLAG)
, EPO.RT_FRZ_PCT_FL_TM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.RT_FRZ_PCT_FL_TM_FLAG)
, EPO.RT_FRZ_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.RT_FRZ_HRS_WKD_FLAG)
, EPO.RT_FRZ_COMB_AGE_AND_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EPO.RT_FRZ_COMB_AGE_AND_LOS_FLAG)
, /* ID COLUMNS */ EPO.ELIG_PER_OPT_ID
, EPO.ELIG_PER_ID
, EPO.BUSINESS_GROUP_ID
, EPO.REQUEST_ID
, EPO.PROGRAM_APPLICATION_ID
, EPO.PROGRAM_ID
, EPO.PER_IN_LER_ID
, EPO.OPT_ID
, /* WHO COLUMNS */ EPO.CREATION_DATE
, EPO.CREATED_BY
, EPO.LAST_UPDATE_DATE
, EPO.LAST_UPDATED_BY
FROM BEN_ELIG_PER_OPT_F EPO
WHERE EPO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EPO.BUSINESS_GROUP_ID) WITH READ ONLY