View: BEN_DSGN_RQMT_D

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

View Text

SELECT DDR.ROWID ROW_ID
, DDR.DSGN_RQMT_ID
, DDR.EFFECTIVE_START_DATE
, DDR.EFFECTIVE_END_DATE
, DDR.MN_DPNTS_RQD_NUM
, DDR.MX_DPNTS_ALWD_NUM
, NO_MN_NUM_DFND.MEANING
, NO_MX_NUM_DFND.MEANING
, CVR_ALL_ELIG.MEANING
, OPT2.NAME
, PL.NAME
, OPT.NAME
, GRP_RLSHP.MEANING
, DSGN_TYP.MEANING
, DDR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_DSGN_RQMT_F DDR
, FND_USER FUSER
, BEN_OIPL_F OIPL
, BEN_PL_F PL
, BEN_OPT_F OPT
, BEN_OPT_F OPT2
, HR_LOOKUPS GRP_RLSHP
, HR_LOOKUPS DSGN_TYP
, HR_LOOKUPS NO_MN_NUM_DFND
, HR_LOOKUPS NO_MX_NUM_DFND
, HR_LOOKUPS CVR_ALL_ELIG
WHERE FUSER.USER_ID (+)= DDR .LAST_UPDATED_BY
AND OIPL.OIPL_ID (+)= DDR .OIPL_ID
AND OIPL.OPT_ID = OPT2.OPT_ID(+)
AND PL.PL_ID (+)= DDR .PL_ID
AND OPT.OPT_ID (+)= DDR .OPT_ID
AND GRP_RLSHP.LOOKUP_CODE (+)= DDR .GRP_RLSHP_CD
AND GRP_RLSHP.LOOKUP_TYPE (+)= 'BEN_GRP_RLSHP'
AND DSGN_TYP.LOOKUP_CODE (+)= DDR .DSGN_TYP_CD
AND DSGN_TYP.LOOKUP_TYPE (+)= 'BEN_DSGN_TYP'
AND NO_MN_NUM_DFND.LOOKUP_CODE (+)= DDR .NO_MN_NUM_DFND_FLAG
AND NO_MN_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_NUM_DFND.LOOKUP_CODE (+)= DDR .NO_MX_NUM_DFND_FLAG
AND NO_MX_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND CVR_ALL_ELIG.LOOKUP_CODE (+)= DDR .CVR_ALL_ELIG_FLAG
AND CVR_ALL_ELIG.LOOKUP_TYPE (+)= 'YES_NO'

Columns