View: BEN_PRTN_ELIGY_RL_D

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

View Text

SELECT CER.ROWID ROW_ID
, CER.PRTN_ELIGY_RL_ID
, CER.EFFECTIVE_START_DATE
, CER.EFFECTIVE_END_DATE
, PRTN_ELIG.WAIT_PERD_UOM
, FORMULA_NAME
, DRVBL_FCTR_APLS.MEANING
, MNDTRY.MEANING
, CER.ORDR_TO_APLY_NUM
, CER.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PRTN_ELIGY_RL_F CER
, FND_USER FUSER
, BEN_PRTN_ELIG_F PRTN_ELIG
, FF_FORMULAS_F FORMULA
, HR_LOOKUPS DRVBL_FCTR_APLS
, HR_LOOKUPS MNDTRY
WHERE FUSER.USER_ID (+)= CER .LAST_UPDATED_BY
AND PRTN_ELIG.PRTN_ELIG_ID (+)= CER .PRTN_ELIG_ID
AND FORMULA.FORMULA_ID (+)= CER .FORMULA_ID
AND DRVBL_FCTR_APLS.LOOKUP_CODE (+)= CER .DRVBL_FCTR_APLS_FLAG
AND DRVBL_FCTR_APLS.LOOKUP_TYPE (+)= 'YES_NO'
AND MNDTRY.LOOKUP_CODE (+)= CER .MNDTRY_FLAG
AND MNDTRY.LOOKUP_TYPE (+)= 'YES_NO'

Columns