View: BENBV_DSGN_RQMT_RLSHP_TYP_V

Product:	BEN - Advanced Benefits
Description:	This view identifies designation restrictions based on the designees' relationship to the participant for a plan, option in plan, or option.
Implementation/DBA Data:	APPS.BENBV_DSGN_RQMT_RLSHP_TYP_V

View Text

SELECT /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_DSGN_RQMT_RLSHP_TYP_F:DRR'
, /* CODES */ DRR.RLSHP_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('CONTACT'
, DRR.RLSHP_TYP_CD)
, /* ID COLUMNS */ DRR.DSGN_RQMT_RLSHP_TYP_ID
, DRR.BUSINESS_GROUP_ID
, DRR.DSGN_RQMT_ID
, /* WHO COLUMNS */ DRR.LAST_UPDATE_DATE
, DRR.LAST_UPDATED_BY
, DRR.CREATED_BY
, DRR.CREATION_DATE
FROM BEN_DSGN_RQMT_RLSHP_TYP DRR
WHERE DRR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, DRR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns