Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies for a plan, option in plan, or option, the designation restrictions based on relationship and/or number of dependents or beneficiaries designatable. |
Implementation/DBA Data: | APPS.BENBV_DSGN_RQMT_V |
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