VIEW: APPS.BENBV_ELIGY_PRFL_V

Source

View Text - Preformatted

SELECT ELP.EFFECTIVE_START_DATE, ELP.EFFECTIVE_END_DATE, ELP.NAME, ELP.DESCRIPTION, /* descriptive flexfield */ '_DF:BEN:BEN_ELIGY_PRFL_F:ELP', /* codes */ ELP.STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT',ELP.STAT_CD), ELP.ASG_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ASGN_TYP',ELP.ASG_TYP_CD), ELP.ASMT_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ASMT_TO_USE',ELP.ASMT_TO_USE_CD), ELP.BNFT_CAGR_PRTN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_CAGR_PRTN',ELP.BNFT_CAGR_PRTN_CD), ELP.ELIG_ENRLD_PLIP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ENRLD_PLIP_FLAG), ELP.ELIG_CBR_QUALD_BNF_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_CBR_QUALD_BNF_FLAG), ELP.ELIG_ENRLD_PTIP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ENRLD_PTIP_FLAG), ELP.ELIG_DPNT_CVRD_PLIP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DPNT_CVRD_PLIP_FLAG), ELP.ELIG_DPNT_CVRD_PTIP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DPNT_CVRD_PTIP_FLAG), ELP.ELIG_DPNT_CVRD_PGM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DPNT_CVRD_PGM_FLAG), ELP.ELIG_JOB_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_JOB_FLAG), ELP.ELIG_HRLY_SLRD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_HRLY_SLRD_FLAG), ELP.ELIG_PSTL_CD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PSTL_CD_FLAG), ELP.ELIG_LBR_MMBR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_LBR_MMBR_FLAG), ELP.ELIG_LGL_ENTY_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_LGL_ENTY_FLAG), ELP.ELIG_BENFTS_GRP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_BENFTS_GRP_FLAG), ELP.ELIG_WK_LOC_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_WK_LOC_FLAG), ELP.ELIG_BRGNG_UNIT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_BRGNG_UNIT_FLAG), ELP.ELIG_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_AGE_FLAG), ELP.ELIG_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_LOS_FLAG), ELP.ELIG_PER_TYP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PER_TYP_FLAG), ELP.ELIG_FL_TM_PT_TM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_FL_TM_PT_TM_FLAG), ELP.ELIG_EE_STAT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_EE_STAT_FLAG), ELP.ELIG_GRD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_GRD_FLAG), ELP.ELIG_PCT_FL_TM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PCT_FL_TM_FLAG), ELP.ELIG_ASNT_SET_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ASNT_SET_FLAG), ELP.ELIG_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_HRS_WKD_FLAG), ELP.ELIG_COMP_LVL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_COMP_LVL_FLAG), ELP.ELIG_ORG_UNIT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ORG_UNIT_FLAG), ELP.ELIG_LOA_RSN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_LOA_RSN_FLAG), ELP.ELIG_PYRL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PYRL_FLAG), ELP.ELIG_SCHEDD_HRS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_SCHEDD_HRS_FLAG), ELP.ELIG_PY_BSS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PY_BSS_FLAG), ELP.ELIGY_PRFL_RL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIGY_PRFL_RL_FLAG), ELP.ELIG_CMBN_AGE_LOS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_CMBN_AGE_LOS_FLAG), ELP.CNTNG_PRTN_ELIG_PRFL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.CNTNG_PRTN_ELIG_PRFL_FLAG), ELP.ELIG_PRTT_PL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PRTT_PL_FLAG), ELP.ELIG_PPL_GRP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PPL_GRP_FLAG), ELP.ELIG_SVC_AREA_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_SVC_AREA_FLAG), ELP.ELIG_PTIP_PRTE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PTIP_PRTE_FLAG), ELP.ELIG_NO_OTHR_CVG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_NO_OTHR_CVG_FLAG), ELP.ELIG_ENRLD_PL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ENRLD_PL_FLAG), ELP.ELIG_ENRLD_OIPL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ENRLD_OIPL_FLAG), ELP.ELIG_ENRLD_PGM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ENRLD_PGM_FLAG), ELP.ELIG_DPNT_CVRD_PL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DPNT_CVRD_PL_FLAG), ELP.ELIG_LVG_RSN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_LVG_RSN_FLAG), ELP.ELIG_OPTD_MDCR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_OPTD_MDCR_FLAG), ELP.ELIG_TBCO_USE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_TBCO_USE_FLAG), ELP.ELIG_DPNT_OTHR_PTIP_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DPNT_OTHR_PTIP_FLAG), ELP.ELIG_GNDR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_GNDR_FLAG), ELP.ELIG_DSBLTY_CTG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DSBLTY_CTG_FLAG), ELP.ELIG_DSBLTY_DGR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DSBLTY_DGR_FLAG), ELP.ELIG_DSBLTY_RSN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DSBLTY_RSN_FLAG), ELP.ELIG_MRTL_STS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_MRTL_STS_FLAG), ELP.ELIG_PRBTN_PERD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PRBTN_PERD_FLAG), ELP.ELIG_SP_CLNG_PRG_PT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_SP_CLNG_PRG_PT_FLAG), ELP.ELIG_SUPPL_ROLE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_SUPPL_ROLE_FLAG), ELP.ELIG_QUAL_TITL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_QUAL_TITL_FLAG), ELP.ELIG_PSTN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PSTN_FLAG), ELP.ELIG_ANTHR_PL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_ANTHR_PL_FLAG), ELP.ELIG_HLTH_CVG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_HLTH_CVG_FLAG), ELP.ELIG_DSBLD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_DSBLD_FLAG), ELP.ELIG_TTL_CVG_VOL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_TTL_CVG_VOL_FLAG), ELP.ELIG_TTL_PRTT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_TTL_PRTT_FLAG), ELP.ELIG_COMPTNCY_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_COMPTNCY_FLAG), ELP.ELIG_QUA_IN_GR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_QUA_IN_GR_FLAG), ELP.ELIG_PERF_RTNG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ELP.ELIG_PERF_RTNG_FLAG), /* id columns */ ELP.ELIGY_PRFL_ID, ELP.BUSINESS_GROUP_ID, /* who columns */ ELP.LAST_UPDATE_DATE, ELP.LAST_UPDATED_BY, ELP.CREATED_BY, ELP.CREATION_DATE FROM BEN_ELIGY_PRFL_F ELP WHERE ELP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ELP.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT ELP.EFFECTIVE_START_DATE
, ELP.EFFECTIVE_END_DATE
, ELP.NAME
, ELP.DESCRIPTION
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIGY_PRFL_F:ELP'
, /* CODES */ ELP.STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT'
, ELP.STAT_CD)
, ELP.ASG_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ASGN_TYP'
, ELP.ASG_TYP_CD)
, ELP.ASMT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ASMT_TO_USE'
, ELP.ASMT_TO_USE_CD)
, ELP.BNFT_CAGR_PRTN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_CAGR_PRTN'
, ELP.BNFT_CAGR_PRTN_CD)
, ELP.ELIG_ENRLD_PLIP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ENRLD_PLIP_FLAG)
, ELP.ELIG_CBR_QUALD_BNF_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_CBR_QUALD_BNF_FLAG)
, ELP.ELIG_ENRLD_PTIP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ENRLD_PTIP_FLAG)
, ELP.ELIG_DPNT_CVRD_PLIP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DPNT_CVRD_PLIP_FLAG)
, ELP.ELIG_DPNT_CVRD_PTIP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DPNT_CVRD_PTIP_FLAG)
, ELP.ELIG_DPNT_CVRD_PGM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DPNT_CVRD_PGM_FLAG)
, ELP.ELIG_JOB_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_JOB_FLAG)
, ELP.ELIG_HRLY_SLRD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_HRLY_SLRD_FLAG)
, ELP.ELIG_PSTL_CD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PSTL_CD_FLAG)
, ELP.ELIG_LBR_MMBR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_LBR_MMBR_FLAG)
, ELP.ELIG_LGL_ENTY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_LGL_ENTY_FLAG)
, ELP.ELIG_BENFTS_GRP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_BENFTS_GRP_FLAG)
, ELP.ELIG_WK_LOC_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_WK_LOC_FLAG)
, ELP.ELIG_BRGNG_UNIT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_BRGNG_UNIT_FLAG)
, ELP.ELIG_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_AGE_FLAG)
, ELP.ELIG_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_LOS_FLAG)
, ELP.ELIG_PER_TYP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PER_TYP_FLAG)
, ELP.ELIG_FL_TM_PT_TM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_FL_TM_PT_TM_FLAG)
, ELP.ELIG_EE_STAT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_EE_STAT_FLAG)
, ELP.ELIG_GRD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_GRD_FLAG)
, ELP.ELIG_PCT_FL_TM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PCT_FL_TM_FLAG)
, ELP.ELIG_ASNT_SET_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ASNT_SET_FLAG)
, ELP.ELIG_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_HRS_WKD_FLAG)
, ELP.ELIG_COMP_LVL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_COMP_LVL_FLAG)
, ELP.ELIG_ORG_UNIT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ORG_UNIT_FLAG)
, ELP.ELIG_LOA_RSN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_LOA_RSN_FLAG)
, ELP.ELIG_PYRL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PYRL_FLAG)
, ELP.ELIG_SCHEDD_HRS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_SCHEDD_HRS_FLAG)
, ELP.ELIG_PY_BSS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PY_BSS_FLAG)
, ELP.ELIGY_PRFL_RL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIGY_PRFL_RL_FLAG)
, ELP.ELIG_CMBN_AGE_LOS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_CMBN_AGE_LOS_FLAG)
, ELP.CNTNG_PRTN_ELIG_PRFL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.CNTNG_PRTN_ELIG_PRFL_FLAG)
, ELP.ELIG_PRTT_PL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PRTT_PL_FLAG)
, ELP.ELIG_PPL_GRP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PPL_GRP_FLAG)
, ELP.ELIG_SVC_AREA_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_SVC_AREA_FLAG)
, ELP.ELIG_PTIP_PRTE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PTIP_PRTE_FLAG)
, ELP.ELIG_NO_OTHR_CVG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_NO_OTHR_CVG_FLAG)
, ELP.ELIG_ENRLD_PL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ENRLD_PL_FLAG)
, ELP.ELIG_ENRLD_OIPL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ENRLD_OIPL_FLAG)
, ELP.ELIG_ENRLD_PGM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ENRLD_PGM_FLAG)
, ELP.ELIG_DPNT_CVRD_PL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DPNT_CVRD_PL_FLAG)
, ELP.ELIG_LVG_RSN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_LVG_RSN_FLAG)
, ELP.ELIG_OPTD_MDCR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_OPTD_MDCR_FLAG)
, ELP.ELIG_TBCO_USE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_TBCO_USE_FLAG)
, ELP.ELIG_DPNT_OTHR_PTIP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DPNT_OTHR_PTIP_FLAG)
, ELP.ELIG_GNDR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_GNDR_FLAG)
, ELP.ELIG_DSBLTY_CTG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DSBLTY_CTG_FLAG)
, ELP.ELIG_DSBLTY_DGR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DSBLTY_DGR_FLAG)
, ELP.ELIG_DSBLTY_RSN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DSBLTY_RSN_FLAG)
, ELP.ELIG_MRTL_STS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_MRTL_STS_FLAG)
, ELP.ELIG_PRBTN_PERD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PRBTN_PERD_FLAG)
, ELP.ELIG_SP_CLNG_PRG_PT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_SP_CLNG_PRG_PT_FLAG)
, ELP.ELIG_SUPPL_ROLE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_SUPPL_ROLE_FLAG)
, ELP.ELIG_QUAL_TITL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_QUAL_TITL_FLAG)
, ELP.ELIG_PSTN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PSTN_FLAG)
, ELP.ELIG_ANTHR_PL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_ANTHR_PL_FLAG)
, ELP.ELIG_HLTH_CVG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_HLTH_CVG_FLAG)
, ELP.ELIG_DSBLD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_DSBLD_FLAG)
, ELP.ELIG_TTL_CVG_VOL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_TTL_CVG_VOL_FLAG)
, ELP.ELIG_TTL_PRTT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_TTL_PRTT_FLAG)
, ELP.ELIG_COMPTNCY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_COMPTNCY_FLAG)
, ELP.ELIG_QUA_IN_GR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_QUA_IN_GR_FLAG)
, ELP.ELIG_PERF_RTNG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ELIG_PERF_RTNG_FLAG)
, /* ID COLUMNS */ ELP.ELIGY_PRFL_ID
, ELP.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ ELP.LAST_UPDATE_DATE
, ELP.LAST_UPDATED_BY
, ELP.CREATED_BY
, ELP.CREATION_DATE
FROM BEN_ELIGY_PRFL_F ELP
WHERE ELP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ELP.BUSINESS_GROUP_ID) WITH READ ONLY