VIEW: APPS.BEN_CNTNG_PRTN_PRFL_RT_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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