[Home] [Help]
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
Name |
"_DF:DRR" |
RLSHP_TYP_CD |
RLSHP_TYP_CD_M |
DSGN_RQMT_RLSHP_TYP_ID |
BUSINESS_GROUP_ID |
DSGN_RQMT_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |