VIEW: APPS.BEN_PL_GD_R_SVC_CTFN_D

Source

View Text - Preformatted

SELECT PCT.ROWID ROW_ID , PCT.PL_GD_R_SVC_CTFN_ID , PCT.EFFECTIVE_START_DATE , PCT.EFFECTIVE_END_DATE , PFD.MEANING , LACK_CTFN_DENY_RMBMT.MEANING , RMBMT_CTFN_TYP.MEANING , RQD.MEANING , LACK_CTFN_DENY_RMBMT2.FORMULA_NAME , RQD1.FORMULA_NAME , PCT.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_PL_GD_R_SVC_CTFN_F PCT, FND_USER FUSER ,HR_LOOKUPS RMBMT_CTFN_TYP ,HR_LOOKUPS PFD ,HR_LOOKUPS LACK_CTFN_DENY_RMBMT ,HR_LOOKUPS RQD ,FF_FORMULAS_F LACK_CTFN_DENY_RMBMT2 ,FF_FORMULAS_F RQD1 WHERE FUSER.USER_ID (+)= PCT .LAST_UPDATED_BY AND RMBMT_CTFN_TYP.LOOKUP_CODE (+)= PCT.RMBMT_CTFN_TYP_CD AND RMBMT_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_RMBMT_CTFN_TYP' AND PFD.LOOKUP_CODE (+)= PCT .PFD_FLAG AND PFD.LOOKUP_TYPE (+)= 'YES_NO' AND LACK_CTFN_DENY_RMBMT.LOOKUP_CODE (+)= PCT.LACK_CTFN_DENY_RMBMT_FLAG AND LACK_CTFN_DENY_RMBMT.LOOKUP_TYPE (+)= 'YES_NO' AND RQD.LOOKUP_CODE (+)= PCT.RQD_FLAG AND RQD.LOOKUP_TYPE (+)= 'YES_NO' AND LACK_CTFN_DENY_RMBMT2.FORMULA_ID (+)= PCT.LACK_CTFN_DENY_RMBMT_RL AND PCT .EFFECTIVE_START_DATE BETWEEN LACK_CTFN_DENY_RMBMT2.EFFECTIVE_START_DATE(+) AND LACK_CTFN_DENY_RMBMT2.EFFECTIVE_END_DATE(+) AND RQD1.FORMULA_ID (+)= PCT.CTFN_RQD_WHEN_RL AND PCT .EFFECTIVE_START_DATE BETWEEN RQD1.EFFECTIVE_START_DATE(+) AND RQD1.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT PCT.ROWID ROW_ID
, PCT.PL_GD_R_SVC_CTFN_ID
, PCT.EFFECTIVE_START_DATE
, PCT.EFFECTIVE_END_DATE
, PFD.MEANING
, LACK_CTFN_DENY_RMBMT.MEANING
, RMBMT_CTFN_TYP.MEANING
, RQD.MEANING
, LACK_CTFN_DENY_RMBMT2.FORMULA_NAME
, RQD1.FORMULA_NAME
, PCT.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PL_GD_R_SVC_CTFN_F PCT
, FND_USER FUSER
, HR_LOOKUPS RMBMT_CTFN_TYP
, HR_LOOKUPS PFD
, HR_LOOKUPS LACK_CTFN_DENY_RMBMT
, HR_LOOKUPS RQD
, FF_FORMULAS_F LACK_CTFN_DENY_RMBMT2
, FF_FORMULAS_F RQD1
WHERE FUSER.USER_ID (+)= PCT .LAST_UPDATED_BY
AND RMBMT_CTFN_TYP.LOOKUP_CODE (+)= PCT.RMBMT_CTFN_TYP_CD
AND RMBMT_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_RMBMT_CTFN_TYP'
AND PFD.LOOKUP_CODE (+)= PCT .PFD_FLAG
AND PFD.LOOKUP_TYPE (+)= 'YES_NO'
AND LACK_CTFN_DENY_RMBMT.LOOKUP_CODE (+)= PCT.LACK_CTFN_DENY_RMBMT_FLAG
AND LACK_CTFN_DENY_RMBMT.LOOKUP_TYPE (+)= 'YES_NO'
AND RQD.LOOKUP_CODE (+)= PCT.RQD_FLAG
AND RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND LACK_CTFN_DENY_RMBMT2.FORMULA_ID (+)= PCT.LACK_CTFN_DENY_RMBMT_RL
AND PCT .EFFECTIVE_START_DATE BETWEEN LACK_CTFN_DENY_RMBMT2.EFFECTIVE_START_DATE(+)
AND LACK_CTFN_DENY_RMBMT2.EFFECTIVE_END_DATE(+)
AND RQD1.FORMULA_ID (+)= PCT.CTFN_RQD_WHEN_RL
AND PCT .EFFECTIVE_START_DATE BETWEEN RQD1.EFFECTIVE_START_DATE(+)
AND RQD1.EFFECTIVE_END_DATE(+)