View: BEN_ELIG_PER_D

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

View Text

SELECT PEP.ROWID ROW_ID
, PEP.ELIG_PER_ID
, PEP.EFFECTIVE_START_DATE
, PEP.EFFECTIVE_END_DATE
, LER.NAME LER_NAME
, DPNT_OTHR_PL_CVRD_RL.MEANING DPNT_OTHR_PL_CVRD_RL_MEANING
, PEP.PRTN_OVRIDN_THRU_DT
, PL_KEY_EE.MEANING PL_KEY_EE_MEANING
, PL_HGHLY_COMPD.MEANING PL_HGHLY_COMPD_MEANING
, ELIG.MEANING ELIG_MEANING
, PEP.COMP_REF_AMT
, PEP.CMBN_AGE_N_LOS_VAL
, COMP_REF.NAME COMP_REF_MEANING
, PEP.AGE_VAL
, PEP.LOS_VAL
, PEP.PRTN_END_DT
, PEP.PRTN_STRT_DT
, WV_CTFN_TYP.MEANING WV_CTFN_TYP_MEANING
, PEP.HRS_WKD_VAL
, HRS_WKD_BNDRY_PERD.MEANING HRS_WKD_BNDRY_PERD_MEANING
, PRTN_OVRIDN.MEANING PRTN_OVRIDN_MEANING
, NO_MX_PRTN_OVRID_THRU.MEANING NO_MX_PRTN_OVRID_THRU_MEANING
, PRTN_OVRIDN_RSN.MEANING PRTN_OVRIDN_RSN_MEANING
, AGE.MEANING AGE_MEANING
, LOS.MEANING LOS_MEANING
, PEP.OVRID_SVC_DT
, FRZ_AGE.MEANING FRZ_AGE_MEANING
, FRZ_CMP_LVL.MEANING FRZ_CMP_LVL_MEANING
, FRZ_HRS_WKD.MEANING FRZ_HRS_WKD_MEANING
, DSTR_RSTCN.MEANING DSTR_RSTCN_MEANING
, PEP.PCT_FL_TM_VAL
, WV_PRTN_RSN.MEANING WV_PRTN_RSN_MEANING
, PL_WVD.MEANING PL_WVD_MEANING
, ONCE_R_CNTNG.MEANING HRS_WKD_QUAL_MEANING
, PEP.WAIT_PERD_CMPLTN_DT
, PEP.WAIT_PERD_STRT_DT
, FUSER.USER_NAME LAST_UPDATED_BY
, PEP.LAST_UPDATE_DATE
FROM BEN_ELIG_PER_F PEP
, BEN_PER_IN_LER PIL
, FND_USER FUSER
, BEN_LER_F LER
, PER_ALL_PEOPLE_F PERSON
, HR_LOOKUPS WV_CTFN_TYP
, HR_LOOKUPS HRS_WKD_BNDRY_PERD
, HR_LOOKUPS PRTN_OVRIDN_RSN
, HR_LOOKUPS WV_PRTN_RSN
, FND_CURRENCIES_TL COMP_REF
, HR_LOOKUPS AGE
, HR_LOOKUPS LOS
, HR_LOOKUPS PL_KEY_EE
, HR_LOOKUPS PL_HGHLY_COMPD
, HR_LOOKUPS ELIG
, HR_LOOKUPS PRTN_OVRIDN
, HR_LOOKUPS NO_MX_PRTN_OVRID_THRU
, HR_LOOKUPS FRZ_AGE
, HR_LOOKUPS FRZ_CMP_LVL
, HR_LOOKUPS FRZ_HRS_WKD
, HR_LOOKUPS DSTR_RSTCN
, HR_LOOKUPS PL_WVD
, HR_LOOKUPS DPNT_OTHR_PL_CVRD_RL
, HR_LOOKUPS ONCE_R_CNTNG
WHERE FUSER.USER_ID (+)= PEP.LAST_UPDATED_BY
AND LER.LER_ID (+)= PEP.LER_ID
AND PERSON.PERSON_ID (+)= PEP.PERSON_ID
AND WV_CTFN_TYP.LOOKUP_CODE (+)= PEP.WV_CTFN_TYP_CD
AND WV_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_WV_PRTN_CTFN_TYP'
AND HRS_WKD_BNDRY_PERD.LOOKUP_CODE (+)= PEP.HRS_WKD_BNDRY_PERD_CD
AND HRS_WKD_BNDRY_PERD.LOOKUP_TYPE (+)= 'BEN_BNDRY_PERD'
AND PRTN_OVRIDN_RSN.LOOKUP_CODE (+)= PEP.PRTN_OVRIDN_RSN_CD
AND PRTN_OVRIDN_RSN.LOOKUP_TYPE (+)= 'BEN_OVRID_RSN'
AND WV_PRTN_RSN.LOOKUP_CODE (+)= PEP.WV_PRTN_RSN_CD
AND WV_PRTN_RSN.LOOKUP_TYPE (+)= 'BEN_WV_PRTN_RSN'
AND COMP_REF.CURRENCY_CODE(+) = PEP.COMP_REF_UOM
AND AGE.LOOKUP_CODE (+)= PEP.AGE_UOM
AND AGE.LOOKUP_TYPE (+)= 'BEN_TM_UOM'
AND LOS.LOOKUP_CODE (+)= PEP.LOS_UOM
AND LOS.LOOKUP_TYPE (+)= 'BEN_TM_UOM'
AND PL_KEY_EE.LOOKUP_CODE(+) = PEP.PL_KEY_EE_FLAG
AND PL_KEY_EE.LOOKUP_TYPE(+) = 'YES_NO'
AND PL_HGHLY_COMPD.LOOKUP_CODE(+) = PEP.PL_HGHLY_COMPD_FLAG
AND PL_HGHLY_COMPD.LOOKUP_TYPE(+) = 'YES_NO'
AND ELIG.LOOKUP_CODE(+) = PEP.ELIG_FLAG
AND ELIG.LOOKUP_TYPE(+) = 'YES_NO'
AND PRTN_OVRIDN.LOOKUP_CODE(+) = PEP.PRTN_OVRIDN_FLAG
AND PRTN_OVRIDN.LOOKUP_TYPE(+) = 'YES_NO'
AND NO_MX_PRTN_OVRID_THRU.LOOKUP_CODE(+) = PEP.NO_MX_PRTN_OVRID_THRU_FLAG
AND NO_MX_PRTN_OVRID_THRU.LOOKUP_TYPE(+) = 'YES_NO'
AND FRZ_AGE.LOOKUP_CODE(+) = PEP.FRZ_AGE_FLAG
AND FRZ_AGE.LOOKUP_TYPE(+) = 'YES_NO'
AND FRZ_CMP_LVL.LOOKUP_CODE(+) = PEP.FRZ_CMP_LVL_FLAG
AND FRZ_CMP_LVL.LOOKUP_TYPE(+) = 'YES_NO'
AND FRZ_HRS_WKD.LOOKUP_CODE(+) = PEP.FRZ_HRS_WKD_FLAG
AND FRZ_HRS_WKD.LOOKUP_TYPE(+) = 'YES_NO'
AND DSTR_RSTCN.LOOKUP_CODE(+) = PEP.DSTR_RSTCN_FLAG
AND DSTR_RSTCN.LOOKUP_TYPE(+) = 'YES_NO'
AND PL_WVD.LOOKUP_CODE(+) = PEP.PL_WVD_FLAG
AND PL_WVD.LOOKUP_TYPE(+) = 'YES_NO'
AND DPNT_OTHR_PL_CVRD_RL.LOOKUP_CODE(+) = PEP.DPNT_OTHR_PL_CVRD_RL_FLAG
AND DPNT_OTHR_PL_CVRD_RL.LOOKUP_TYPE(+) = 'YES_NO'
AND ONCE_R_CNTNG.LOOKUP_CODE(+) = PEP.ONCE_R_CNTUG_CD
AND ONCE_R_CNTNG.LOOKUP_TYPE(+) = 'BEN_ONCE_R_CNTNG'
AND PIL.PER_IN_LER_ID(+)=PEP.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PEP.BUSINESS_GROUP_ID
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )

Columns