View: HR_ATH_ELIGIBLE_ALL_PLANS_V

Product:	PER - Human Resources
Description:	View to support Authoria Integration
Implementation/DBA Data:	APPS.HR_ATH_ELIGIBLE_ALL_PLANS_V

View Text

SELECT DISTINCT TO_CHAR(PIL.PERSON_ID) EMPLOYEE_ID
, TO_CHAR(ECH.PL_ID)||'A'||TO_CHAR(ECH.PLIP_ID) PLAN_ID
, PEL.ENRT_PERD_STRT_DT START_DATE
, NVL(PEL.ENRT_PERD_END_DT
, TO_DATE('12/31/4712'
, 'MM/DD/YYYY')) END_DATE
FROM BEN_ELIG_PER_ELCTBL_CHC ECH
, BEN_PER_IN_LER PIL
, BEN_PIL_ELCTBL_CHC_POPL PEL
WHERE PIL.PER_IN_LER_ID = ECH.PER_IN_LER_ID
AND PIL.PER_IN_LER_ID = PEL.PER_IN_LER_ID
AND PEL.PIL_ELCTBL_CHC_POPL_ID = ECH.PIL_ELCTBL_CHC_POPL_ID
AND PIL.PER_IN_LER_STAT_CD = 'STRTD'
AND ECH.PL_ID IS NOT NULL

Columns