VIEW: APPS.BEN_FLX_ENRT_UOM_INFO_V

Source

View Text - Preformatted

SELECT DISTINCT pel.UOM , pel.ACTY_REF_PERD_CD , HL1.MEANING , PIL.PERSON_ID , PIL.LER_ID , EPE.PER_IN_LER_ID , EPE.PGM_ID , EPE.BUSINESS_GROUP_ID FROM BEN_ELIG_PER_ELCTBL_CHC EPE , BEN_pil_elctbl_chc_popl pel , BEN_PER_IN_LER PIL , HR_LOOKUPS HL1 , FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN NVL(HL1.START_DATE_ACTIVE , SE.EFFECTIVE_DATE) AND NVL(HL1.END_DATE_ACTIVE , SE.EFFECTIVE_DATE) AND HL1.ENABLED_FLAG = 'Y' AND HL1.LOOKUP_TYPE = 'BEN_ACTY_REF_PERD' AND pel.ACTY_REF_PERD_CD = HL1.LOOKUP_CODE AND PIL.PER_IN_LER_ID = pel.PER_IN_LER_ID AND pel.pgm_id = epe.pgm_id and pil.per_in_ler_id=epe.per_in_ler_id and pil.business_group_id+0=epe.business_group_id+0 and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

View Text - HTML Formatted

SELECT DISTINCT PEL.UOM
, PEL.ACTY_REF_PERD_CD
, HL1.MEANING
, PIL.PERSON_ID
, PIL.LER_ID
, EPE.PER_IN_LER_ID
, EPE.PGM_ID
, EPE.BUSINESS_GROUP_ID
FROM BEN_ELIG_PER_ELCTBL_CHC EPE
, BEN_PIL_ELCTBL_CHC_POPL PEL
, BEN_PER_IN_LER PIL
, HR_LOOKUPS HL1
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN NVL(HL1.START_DATE_ACTIVE
, SE.EFFECTIVE_DATE)
AND NVL(HL1.END_DATE_ACTIVE
, SE.EFFECTIVE_DATE)
AND HL1.ENABLED_FLAG = 'Y'
AND HL1.LOOKUP_TYPE = 'BEN_ACTY_REF_PERD'
AND PEL.ACTY_REF_PERD_CD = HL1.LOOKUP_CODE
AND PIL.PER_IN_LER_ID = PEL.PER_IN_LER_ID
AND PEL.PGM_ID = EPE.PGM_ID
AND PIL.PER_IN_LER_ID=EPE.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID+0=EPE.BUSINESS_GROUP_ID+0
AND PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT')