VIEW: APPS.BEN_CNTNU_PRTN_CTFN_TYP_D

Source

View Text - Preformatted

SELECT CPC.ROWID ROW_ID , CPC.CNTNU_PRTN_CTFN_TYP_ID , CPC.EFFECTIVE_START_DATE , CPC.EFFECTIVE_END_DATE , CNTNG_PRTN_ELIG_PRFL.NAME , PFD.MEANING , LACK_CTFN_SSPND_ELIG.MEANING , CTFN_RQD_WHEN.FORMULA_NAME , PRTN_CTFN_TYP.MEANING , CPC.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_CNTNU_PRTN_CTFN_TYP_F CPC, FND_USER FUSER ,BEN_CNTNG_PRTN_ELIG_PRFL_F CNTNG_PRTN_ELIG_PRFL ,HR_LOOKUPS PRTN_CTFN_TYP ,HR_LOOKUPS PFD ,HR_LOOKUPS LACK_CTFN_SSPND_ELIG ,FF_FORMULAS_F CTFN_RQD_WHEN WHERE FUSER.USER_ID (+)= CPC.LAST_UPDATED_BY AND CNTNG_PRTN_ELIG_PRFL.CNTNG_PRTN_ELIG_PRFL_ID (+)= CPC.CNTNG_PRTN_ELIG_PRFL_ID AND PRTN_CTFN_TYP.LOOKUP_CODE (+)= CPC.PRTN_CTFN_TYP_CD AND PRTN_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_PRTN_CTFN_TYP' AND PFD.LOOKUP_CODE (+)= CPC.PFD_FLAG AND PFD.LOOKUP_TYPE (+)= 'YES_NO' AND LACK_CTFN_SSPND_ELIG.LOOKUP_CODE (+)= CPC.LACK_CTFN_SSPND_ELIG_FLAG AND LACK_CTFN_SSPND_ELIG.LOOKUP_TYPE (+)= 'YES_NO' AND CTFN_RQD_WHEN.FORMULA_ID (+)= CPC.CTFN_RQD_WHEN_RL AND CPC.EFFECTIVE_START_DATE BETWEEN CTFN_RQD_WHEN.EFFECTIVE_START_DATE AND CTFN_RQD_WHEN.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT CPC.ROWID ROW_ID
, CPC.CNTNU_PRTN_CTFN_TYP_ID
, CPC.EFFECTIVE_START_DATE
, CPC.EFFECTIVE_END_DATE
, CNTNG_PRTN_ELIG_PRFL.NAME
, PFD.MEANING
, LACK_CTFN_SSPND_ELIG.MEANING
, CTFN_RQD_WHEN.FORMULA_NAME
, PRTN_CTFN_TYP.MEANING
, CPC.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_CNTNU_PRTN_CTFN_TYP_F CPC
, FND_USER FUSER
, BEN_CNTNG_PRTN_ELIG_PRFL_F CNTNG_PRTN_ELIG_PRFL
, HR_LOOKUPS PRTN_CTFN_TYP
, HR_LOOKUPS PFD
, HR_LOOKUPS LACK_CTFN_SSPND_ELIG
, FF_FORMULAS_F CTFN_RQD_WHEN
WHERE FUSER.USER_ID (+)= CPC.LAST_UPDATED_BY
AND CNTNG_PRTN_ELIG_PRFL.CNTNG_PRTN_ELIG_PRFL_ID (+)= CPC.CNTNG_PRTN_ELIG_PRFL_ID
AND PRTN_CTFN_TYP.LOOKUP_CODE (+)= CPC.PRTN_CTFN_TYP_CD
AND PRTN_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_PRTN_CTFN_TYP'
AND PFD.LOOKUP_CODE (+)= CPC.PFD_FLAG
AND PFD.LOOKUP_TYPE (+)= 'YES_NO'
AND LACK_CTFN_SSPND_ELIG.LOOKUP_CODE (+)= CPC.LACK_CTFN_SSPND_ELIG_FLAG
AND LACK_CTFN_SSPND_ELIG.LOOKUP_TYPE (+)= 'YES_NO'
AND CTFN_RQD_WHEN.FORMULA_ID (+)= CPC.CTFN_RQD_WHEN_RL
AND CPC.EFFECTIVE_START_DATE BETWEEN CTFN_RQD_WHEN.EFFECTIVE_START_DATE
AND CTFN_RQD_WHEN.EFFECTIVE_END_DATE