View: BEN_CM_TYP_D

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

View Text

SELECT CCT.ROWID ROW_ID
, CCT.CM_TYP_ID
, CCT.EFFECTIVE_START_DATE
, CCT.EFFECTIVE_END_DATE
, CCT.NAME
, CCT.DESC_TXT
, CM_TYP.FORMULA_NAME
, CM_USG.MEANING
, WHNVR_TRGRD.MEANING
, CCT.SHRT_NAME
, PC_KIT.MEANING
, TRK_MLG.MEANING
, CCT.MX_NUM_AVLBL_VAL
, TO_BE_SENT_DT.MEANING
, TO_BE_SENT_DT_B.FORMULA_NAME
, INSPN_RQD.MEANING
, INSPN_RQD_B.FORMULA_NAME
, RCPENT.MEANING
, PARNT_CM_TYP.NAME
, CCT.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM BEN_CM_TYP_F CCT
, FND_USER FUSER
, BEN_CM_TYP_F PARNT_CM_TYP
, HR_LOOKUPS CM_USG
, HR_LOOKUPS PC_KIT
, HR_LOOKUPS TO_BE_SENT_DT
, HR_LOOKUPS RCPENT
, HR_LOOKUPS WHNVR_TRGRD
, HR_LOOKUPS TRK_MLG
, HR_LOOKUPS INSPN_RQD
, FF_FORMULAS_F CM_TYP
, FF_FORMULAS_F TO_BE_SENT_DT_B
, FF_FORMULAS_F INSPN_RQD_B
WHERE FUSER.USER_ID (+)= CCT .LAST_UPDATED_BY
AND PARNT_CM_TYP.PARNT_CM_TYP_ID (+)= CCT .PARNT_CM_TYP_ID
AND CM_USG.LOOKUP_CODE (+)= CCT .CM_USG_CD
AND CM_USG.LOOKUP_TYPE (+)= 'BEN_CM_USG'
AND PC_KIT.LOOKUP_CODE (+)= CCT .PC_KIT_CD
AND PC_KIT.LOOKUP_TYPE (+)= 'BEN_PC_KIT'
AND TO_BE_SENT_DT.LOOKUP_CODE (+)= CCT .TO_BE_SENT_DT_CD
AND TO_BE_SENT_DT.LOOKUP_TYPE (+)= 'BEN_TO_BE_SENT_DT'
AND RCPENT.LOOKUP_CODE (+)= CCT .RCPENT_CD
AND RCPENT.LOOKUP_TYPE (+)= 'BEN_RCPENT'
AND WHNVR_TRGRD.LOOKUP_CODE (+)= CCT .WHNVR_TRGRD_FLAG
AND WHNVR_TRGRD.LOOKUP_TYPE (+)= 'YES_NO'
AND TRK_MLG.LOOKUP_CODE (+)= CCT .TRK_MLG_FLAG
AND TRK_MLG.LOOKUP_TYPE (+)= 'YES_NO'
AND INSPN_RQD.LOOKUP_CODE (+)= CCT .INSPN_RQD_FLAG
AND INSPN_RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND CM_TYP.FORMULA_ID (+)= CCT .CM_TYP_RL
AND CCT .EFFECTIVE_START_DATE BETWEEN CM_TYP.EFFECTIVE_START_DATE(+)
AND CM_TYP.EFFECTIVE_END_DATE(+)
AND TO_BE_SENT_DT_B.FORMULA_ID (+)= CCT .TO_BE_SENT_DT_RL
AND CCT .EFFECTIVE_START_DATE BETWEEN TO_BE_SENT_DT_B.EFFECTIVE_START_DATE(+)
AND TO_BE_SENT_DT_B.EFFECTIVE_END_DATE(+)
AND INSPN_RQD_B.FORMULA_ID (+)= CCT .INSPN_RQD_RL
AND CCT .EFFECTIVE_START_DATE BETWEEN INSPN_RQD_B.EFFECTIVE_START_DATE(+)
AND INSPN_RQD_B.EFFECTIVE_END_DATE(+)

Columns