Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_PER_OPT_D |
SELECT EPO.ROWID ROW_ID
, EPO.ELIG_PER_OPT_ID
, EPO.EFFECTIVE_START_DATE
, EPO.EFFECTIVE_END_DATE
, OPT.NAME OPT_NAME
, ELIG.MEANING ELIG_MEANING
, EPO.WAIT_PERD_CMPLTN_DT
, EPO.WAIT_PERD_CMPLTN_DATE
, EPO.WAIT_PERD_STRT_DT
, EPO.PRTN_STRT_DT
, EPO.PRTN_END_DT
, OVRIDN.MEANING OVRIDN_MEANING
, NO_MX_PRTN_OVRID_THRU.MEANING NO_MX_PRTN_OVRID_THRU_MEANING
, ONCE_R_CNTNG.MEANING HRS_WKD_QUAL_MEANING
, EPO.PRTN_OVRIDN_THRU_DT
, PRTN_OVRIDN_RSN.MEANING PRTN_OVRIDN_RSN_MEANING
, FUSER.USER_NAME LAST_UPDATED_BY
, EPO.LAST_UPDATE_DATE
FROM BEN_ELIG_PER_OPT_F EPO
, BEN_OPT_F OPT
, FND_USER FUSER
, HR_LOOKUPS ELIG
, HR_LOOKUPS OVRIDN
, HR_LOOKUPS NO_MX_PRTN_OVRID_THRU
, HR_LOOKUPS PRTN_OVRIDN_RSN
, HR_LOOKUPS ONCE_R_CNTNG
WHERE OPT.OPT_ID (+)= EPO.OPT_ID
AND FUSER.USER_ID (+)= EPO.LAST_UPDATED_BY
AND ELIG.LOOKUP_CODE = EPO.ELIG_FLAG
AND ELIG.LOOKUP_TYPE = 'YES_NO'
AND OVRIDN.LOOKUP_CODE = EPO.PRTN_OVRIDN_FLAG
AND OVRIDN.LOOKUP_TYPE = 'YES_NO'
AND NO_MX_PRTN_OVRID_THRU.LOOKUP_CODE = EPO.NO_MX_PRTN_OVRID_THRU_FLAG
AND NO_MX_PRTN_OVRID_THRU.LOOKUP_TYPE = 'YES_NO'
AND PRTN_OVRIDN_RSN.LOOKUP_CODE (+)= EPO.PRTN_OVRIDN_RSN_CD
AND PRTN_OVRIDN_RSN.LOOKUP_TYPE (+)= 'BEN_OVRID_RSN'
AND ONCE_R_CNTNG.LOOKUP_CODE(+) = EPO.ONCE_R_CNTUG_CD
AND ONCE_R_CNTNG.LOOKUP_TYPE(+) = 'BEN_ONCE_R_CNTNG'