VIEW: APPS.BENBV_PRTT_ENRT_RSLT_V

Source

View Text - Preformatted

SELECT PEN.EFFECTIVE_START_DATE, PEN.EFFECTIVE_END_DATE, PEN.ENRT_CVG_STRT_DT, PEN.ENRT_CVG_THRU_DT, PEN.PL_ORDR_NUM, PEN.PLIP_ORDR_NUM, PEN.PTIP_ORDR_NUM, PEN.OIPL_ORDR_NUM, PEN.PROGRAM_UPDATE_DATE, PEN.BNFT_AMT, PEN.BNFT_NNMNTRY_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM',PEN.BNFT_NNMNTRY_UOM), PEN.UOM, PEN.ORGNL_ENRT_DT, PEN.ERLST_DEENRT_DT, PEN.ENRT_OVRID_THRU_DT, PEN.BNFT_ORDR_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_PRTT_ENRT_RSLT_F:PEN', /* codes */ PEN.ENRT_MTHD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_RSLT_MTHD',PEN.ENRT_MTHD_CD), PEN.BNFT_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_TYP',PEN.BNFT_TYP_CD), PEN.ENRT_OVRID_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_OVRID_RSN',PEN.ENRT_OVRID_RSN_CD), PEN.PRTT_ENRT_RSLT_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTT_ENRT_RSLT_STAT',PEN.PRTT_ENRT_RSLT_STAT_CD), PEN.COMP_LVL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_COMP_LVL',PEN.COMP_LVL_CD), PEN.SSPNDD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEN.SSPNDD_FLAG), PEN.PRTT_IS_CVRD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEN.PRTT_IS_CVRD_FLAG), PEN.ENRT_OVRIDN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEN.ENRT_OVRIDN_FLAG), PEN.NO_LNGR_ELIG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PEN.NO_LNGR_ELIG_FLAG), /* id columns */ PEN.PRTT_ENRT_RSLT_ID, PEN.PERSON_ID, PEN.PL_ID, PEN.LER_ID, PEN.BUSINESS_GROUP_ID, PEN.REQUEST_ID, PEN.PROGRAM_APPLICATION_ID, PEN.PROGRAM_ID, PEN.PGM_ID, PEN.PL_TYP_ID, PEN.OIPL_ID, PEN.PTIP_ID, PEN.PER_IN_LER_ID, PEN.ASSIGNMENT_ID, PEN.RPLCS_SSPNDD_RSLT_ID, /* who columns */ PEN.LAST_UPDATE_DATE, PEN.LAST_UPDATED_BY, PEN.CREATED_BY, PEN.CREATION_DATE FROM BEN_PRTT_ENRT_RSLT_F PEN WHERE PEN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PEN.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PEN.EFFECTIVE_START_DATE
, PEN.EFFECTIVE_END_DATE
, PEN.ENRT_CVG_STRT_DT
, PEN.ENRT_CVG_THRU_DT
, PEN.PL_ORDR_NUM
, PEN.PLIP_ORDR_NUM
, PEN.PTIP_ORDR_NUM
, PEN.OIPL_ORDR_NUM
, PEN.PROGRAM_UPDATE_DATE
, PEN.BNFT_AMT
, PEN.BNFT_NNMNTRY_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, PEN.BNFT_NNMNTRY_UOM)
, PEN.UOM
, PEN.ORGNL_ENRT_DT
, PEN.ERLST_DEENRT_DT
, PEN.ENRT_OVRID_THRU_DT
, PEN.BNFT_ORDR_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTT_ENRT_RSLT_F:PEN'
, /* CODES */ PEN.ENRT_MTHD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_RSLT_MTHD'
, PEN.ENRT_MTHD_CD)
, PEN.BNFT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_TYP'
, PEN.BNFT_TYP_CD)
, PEN.ENRT_OVRID_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_OVRID_RSN'
, PEN.ENRT_OVRID_RSN_CD)
, PEN.PRTT_ENRT_RSLT_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTT_ENRT_RSLT_STAT'
, PEN.PRTT_ENRT_RSLT_STAT_CD)
, PEN.COMP_LVL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_COMP_LVL'
, PEN.COMP_LVL_CD)
, PEN.SSPNDD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEN.SSPNDD_FLAG)
, PEN.PRTT_IS_CVRD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEN.PRTT_IS_CVRD_FLAG)
, PEN.ENRT_OVRIDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEN.ENRT_OVRIDN_FLAG)
, PEN.NO_LNGR_ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEN.NO_LNGR_ELIG_FLAG)
, /* ID COLUMNS */ PEN.PRTT_ENRT_RSLT_ID
, PEN.PERSON_ID
, PEN.PL_ID
, PEN.LER_ID
, PEN.BUSINESS_GROUP_ID
, PEN.REQUEST_ID
, PEN.PROGRAM_APPLICATION_ID
, PEN.PROGRAM_ID
, PEN.PGM_ID
, PEN.PL_TYP_ID
, PEN.OIPL_ID
, PEN.PTIP_ID
, PEN.PER_IN_LER_ID
, PEN.ASSIGNMENT_ID
, PEN.RPLCS_SSPNDD_RSLT_ID
, /* WHO COLUMNS */ PEN.LAST_UPDATE_DATE
, PEN.LAST_UPDATED_BY
, PEN.CREATED_BY
, PEN.CREATION_DATE
FROM BEN_PRTT_ENRT_RSLT_F PEN
WHERE PEN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEN.BUSINESS_GROUP_ID) WITH READ ONLY