Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PL_GD_R_SVC_CTFN_D |
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(+)