VIEW: APPS.BEN_PRTN_ELIGY_RL_D

Source

View Text - Preformatted

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' AND cer.effective_start_date between prtn_elig.effective_start_date and cer.effective_end_date AND cer.effective_start_date between formula.effective_start_date and formula.effective_end_date

View Text - HTML Formatted

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'
AND CER.EFFECTIVE_START_DATE BETWEEN PRTN_ELIG.EFFECTIVE_START_DATE
AND CER.EFFECTIVE_END_DATE
AND CER.EFFECTIVE_START_DATE BETWEEN FORMULA.EFFECTIVE_START_DATE
AND FORMULA.EFFECTIVE_END_DATE