VIEW: APPS.BENBV_DSGN_RQMT_V

Source

View Text - Preformatted

SELECT DDR.EFFECTIVE_START_DATE, DDR.EFFECTIVE_END_DATE, DDR.MN_DPNTS_RQD_NUM, DDR.MX_DPNTS_ALWD_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_DSGN_RQMT_F:DDR', /* codes */ DDR.GRP_RLSHP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_GRP_RLSHP',DDR.GRP_RLSHP_CD), DDR.DSGN_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DSGN_TYP',DDR.DSGN_TYP_CD), DDR.NO_MN_NUM_DFND_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DDR.NO_MN_NUM_DFND_FLAG), DDR.NO_MX_NUM_DFND_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DDR.NO_MX_NUM_DFND_FLAG), DDR.CVR_ALL_ELIG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DDR.CVR_ALL_ELIG_FLAG), /* id columns */ DDR.DSGN_RQMT_ID, DDR.BUSINESS_GROUP_ID, DDR.OIPL_ID, DDR.PL_ID, DDR.OPT_ID, /* who columns */ DDR.LAST_UPDATE_DATE, DDR.LAST_UPDATED_BY, DDR.CREATED_BY, DDR.CREATION_DATE FROM BEN_DSGN_RQMT_F DDR WHERE DDR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, DDR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT DDR.EFFECTIVE_START_DATE
, DDR.EFFECTIVE_END_DATE
, DDR.MN_DPNTS_RQD_NUM
, DDR.MX_DPNTS_ALWD_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_DSGN_RQMT_F:DDR'
, /* CODES */ DDR.GRP_RLSHP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_GRP_RLSHP'
, DDR.GRP_RLSHP_CD)
, DDR.DSGN_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DSGN_TYP'
, DDR.DSGN_TYP_CD)
, DDR.NO_MN_NUM_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DDR.NO_MN_NUM_DFND_FLAG)
, DDR.NO_MX_NUM_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DDR.NO_MX_NUM_DFND_FLAG)
, DDR.CVR_ALL_ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DDR.CVR_ALL_ELIG_FLAG)
, /* ID COLUMNS */ DDR.DSGN_RQMT_ID
, DDR.BUSINESS_GROUP_ID
, DDR.OIPL_ID
, DDR.PL_ID
, DDR.OPT_ID
, /* WHO COLUMNS */ DDR.LAST_UPDATE_DATE
, DDR.LAST_UPDATED_BY
, DDR.CREATED_BY
, DDR.CREATION_DATE
FROM BEN_DSGN_RQMT_F DDR
WHERE DDR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, DDR.BUSINESS_GROUP_ID) WITH READ ONLY