VIEW: APPS.BENBV_PIL_ELCTBL_CHC_POPL_V

Source

View Text - Preformatted

SELECT PEL.CBR_ELIG_PERD_STRT_DT, PEL.CBR_ELIG_PERD_END_DT, PEL.PROGRAM_UPDATE_DATE, PEL.DFLT_ENRT_DT, PEL.DFLT_ASND_DT, PEL.ELCNS_MADE_DT, PEL.ENRT_PERD_END_DT, PEL.ENRT_PERD_STRT_DT, PEL.PROCG_END_DT, PEL.UOM, PEL.AUTO_ASND_DT, PEL.BDGT_DUE_DT, PEL.BDGT_ISS_DT, PEL.WS_DUE_DT, PEL.WS_ISS_DT, PEL.COMMENTS, PEL.MGR_OVRID_DT, /* descriptive flexfield */ '_DF:BEN:BEN_PIL_ELCTBL_CHC_POPL:PEL', /* codes */ PEL.CLS_ENRT_DT_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CLS_ENRT_DT_TO_USE',PEL.CLS_ENRT_DT_TO_USE_CD), PEL.ENRT_TYP_CYCL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_TYP_CYCL',PEL.ENRT_TYP_CYCL_CD), PEL.PIL_ELCTBL_POPL_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT',PEL.PIL_ELCTBL_POPL_STAT_CD), PEL.ACTY_REF_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD',PEL.ACTY_REF_PERD_CD), PEL.BDGT_ACC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BDGT_ACC',PEL.BDGT_ACC_CD), PEL.POP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_POP',PEL.POP_CD), PEL.BDGT_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BDGT_STAT',PEL.BDGT_STAT_CD), PEL.WS_ACC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_ACC',PEL.WS_ACC_CD), PEL.WS_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_STAT',PEL.WS_STAT_CD), PEL.BDGT_EXPORT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEL.BDGT_EXPORT_FLAG), PEL.WS_EXPORT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEL.WS_EXPORT_FLAG), /* id columns */ PEL.PIL_ELCTBL_CHC_POPL_ID, PEL.PER_IN_LER_ID, PEL.PGM_ID, PEL.REQUEST_ID, PEL.PROGRAM_APPLICATION_ID, PEL.PROGRAM_ID, PEL.BUSINESS_GROUP_ID, PEL.ENRT_PERD_ID, PEL.LEE_RSN_ID, PEL.PL_ID, PEL.ASSIGNMENT_ID, PEL.MGR_OVRID_PERSON_ID, PEL.WS_MGR_ID, /* who columns */ PEL.LAST_UPDATE_DATE, PEL.LAST_UPDATED_BY, PEL.CREATED_BY, PEL.CREATION_DATE FROM BEN_PIL_ELCTBL_CHC_POPL PEL WHERE PEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PEL.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PEL.CBR_ELIG_PERD_STRT_DT
, PEL.CBR_ELIG_PERD_END_DT
, PEL.PROGRAM_UPDATE_DATE
, PEL.DFLT_ENRT_DT
, PEL.DFLT_ASND_DT
, PEL.ELCNS_MADE_DT
, PEL.ENRT_PERD_END_DT
, PEL.ENRT_PERD_STRT_DT
, PEL.PROCG_END_DT
, PEL.UOM
, PEL.AUTO_ASND_DT
, PEL.BDGT_DUE_DT
, PEL.BDGT_ISS_DT
, PEL.WS_DUE_DT
, PEL.WS_ISS_DT
, PEL.COMMENTS
, PEL.MGR_OVRID_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PIL_ELCTBL_CHC_POPL:PEL'
, /* CODES */ PEL.CLS_ENRT_DT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CLS_ENRT_DT_TO_USE'
, PEL.CLS_ENRT_DT_TO_USE_CD)
, PEL.ENRT_TYP_CYCL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_TYP_CYCL'
, PEL.ENRT_TYP_CYCL_CD)
, PEL.PIL_ELCTBL_POPL_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT'
, PEL.PIL_ELCTBL_POPL_STAT_CD)
, PEL.ACTY_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, PEL.ACTY_REF_PERD_CD)
, PEL.BDGT_ACC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BDGT_ACC'
, PEL.BDGT_ACC_CD)
, PEL.POP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_POP'
, PEL.POP_CD)
, PEL.BDGT_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BDGT_STAT'
, PEL.BDGT_STAT_CD)
, PEL.WS_ACC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_ACC'
, PEL.WS_ACC_CD)
, PEL.WS_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_STAT'
, PEL.WS_STAT_CD)
, PEL.BDGT_EXPORT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.BDGT_EXPORT_FLAG)
, PEL.WS_EXPORT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.WS_EXPORT_FLAG)
, /* ID COLUMNS */ PEL.PIL_ELCTBL_CHC_POPL_ID
, PEL.PER_IN_LER_ID
, PEL.PGM_ID
, PEL.REQUEST_ID
, PEL.PROGRAM_APPLICATION_ID
, PEL.PROGRAM_ID
, PEL.BUSINESS_GROUP_ID
, PEL.ENRT_PERD_ID
, PEL.LEE_RSN_ID
, PEL.PL_ID
, PEL.ASSIGNMENT_ID
, PEL.MGR_OVRID_PERSON_ID
, PEL.WS_MGR_ID
, /* WHO COLUMNS */ PEL.LAST_UPDATE_DATE
, PEL.LAST_UPDATED_BY
, PEL.CREATED_BY
, PEL.CREATION_DATE
FROM BEN_PIL_ELCTBL_CHC_POPL PEL
WHERE PEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEL.BUSINESS_GROUP_ID) WITH READ ONLY