VIEW: APPS.BEN_ELIG_PER_OPT_D

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'