View: BEN_CWB_WS_MGR_LOV_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_CWB_WS_MGR_LOV_V

View Text

SELECT DISTINCT PPF.PERSON_ID ID
, FIRST_NAME ||' ' ||LAST_NAME || ' ' ||SUFFIX VALUE
, PIL.PERSON_ID MANAGER_ID
FROM PER_ALL_PEOPLE_F PPF
, BEN_ELIG_PER_ELCTBL_CHC CHC
, BEN_CWB_MGR_HRCHY HIER
, BEN_CWB_MGR_HRCHY HIER2
, BEN_ELIG_PER_ELCTBL_CHC CHC2
, BEN_PER_IN_LER PIL
, BEN_PER_IN_LER PIL2
WHERE PIL.PER_IN_LER_ID = CHC.PER_IN_LER_ID
AND CHC.ELIG_PER_ELCTBL_CHC_ID = HIER.MGR_ELIG_PER_ELCTBL_CHC_ID
AND HIER.LVL_NUM > 0
AND HIER.EMP_ELIG_PER_ELCTBL_CHC_ID = CHC2.ELIG_PER_ELCTBL_CHC_ID
AND CHC2.ELIG_FLAG = 'Y'
AND CHC2.PER_IN_LER_ID = PIL2.PER_IN_LER_ID
AND PIL2.PER_IN_LER_STAT_CD IN ('STRTD'
, 'PROCD')
AND PIL2.PERSON_ID = PPF.PERSON_ID
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND CHC2.ELIG_PER_ELCTBL_CHC_ID = HIER2.MGR_ELIG_PER_ELCTBL_CHC_ID

Columns