View: BEN_CNTNG_PRTN_PRFL_RT_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_CNTNG_PRTN_PRFL_RT_D

View Text

SELECT CPN.ROWID
, CPN.CNTNG_PRTN_PRFL_RT_ID
, CPN.EFFECTIVE_START_DATE
, CPN.EFFECTIVE_END_DATE
, CPN.VRBL_RT_PRFL_ID
, CPN.BUSINESS_GROUP_ID
, CPN.NAME
, CPN.PYMT_MUST_BE_RCVD_NUM
, HRL.MEANING
, FF.FORMULA_NAME
, CPN.LAST_UPDATE_DATE
, CPN.LAST_UPDATED_BY
, CPN.LAST_UPDATE_LOGIN
, CPN.CREATED_BY
, CPN.CREATION_DATE
, CPN.OBJECT_VERSION_NUMBER
FROM BEN_CNTNG_PRTN_PRFL_RT_F CPN
, FND_USER_VIEW FUSER
, HR_LOOKUPS HRL
, FF_FORMULAS_F FF
WHERE FUSER.USER_ID(+) = CPN.LAST_UPDATED_BY
AND FF.FORMULA_ID(+) = CPN.PYMT_MUST_BE_RCVD_RL
AND HRL.LOOKUP_TYPE(+) = 'BEN_TM_UOM'
AND HRL.LOOKUP_CODE(+) = CPN.PYMT_MUST_BE_RCVD_UOM

Columns