Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_CNTNG_PRTN_ELIG_PRFL_D |
SELECT CGP.ROWID ROW_ID
, CGP.CNTNG_PRTN_ELIG_PRFL_ID
, CGP.EFFECTIVE_START_DATE
, CGP.EFFECTIVE_END_DATE
, ELIGY_PRFL.NAME
, CGP.NAME
, PYMT_MUST_BE_RCVD.MEANING
, CGP.PYMT_MUST_BE_RCVD_NUM
, PYMT_MUST_BE_RCVD2.FORMULA_NAME
, CGP.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_CNTNG_PRTN_ELIG_PRFL_F CGP
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS PYMT_MUST_BE_RCVD
, FF_FORMULAS_F PYMT_MUST_BE_RCVD2
WHERE FUSER.USER_ID (+)= CGP .LAST_UPDATED_BY
AND ELIGY_PRFL.ELIGY_PRFL_ID (+)= CGP .ELIGY_PRFL_ID
AND PYMT_MUST_BE_RCVD.LOOKUP_CODE (+)= CGP .PYMT_MUST_BE_RCVD_UOM
AND PYMT_MUST_BE_RCVD.LOOKUP_TYPE (+)= 'BEN_PYMT_MUST_BE_RECD'
AND PYMT_MUST_BE_RCVD2.FORMULA_ID (+)= CGP .PYMT_MUST_BE_RCVD_RL
AND CGP .EFFECTIVE_START_DATE BETWEEN PYMT_MUST_BE_RCVD2.EFFECTIVE_START_DATE
AND PYMT_MUST_BE_RCVD2.EFFECTIVE_END_DATE