Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the relationship that must exist between the participant and dependent in order for a participant to designate a dependent for an enrollment. |
Implementation/DBA Data: | APPS.BENBV_DPNT_CVG_RQD_RLSHP_V |
SELECT DCR.EFFECTIVE_START_DATE
, DCR.EFFECTIVE_END_DATE
, DCR.CVG_THRU_DT_RL
, DCR.CVG_STRT_DT_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_DPNT_CVG_RQD_RLSHP_F:DCR'
, /* CODES */ DCR.PER_RELSHP_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('CONTACT'
, DCR.PER_RELSHP_TYP_CD)
, DCR.CVG_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_START'
, DCR.CVG_STRT_DT_CD)
, DCR.CVG_THRU_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_END'
, DCR.CVG_THRU_DT_CD)
, /* ID COLUMNS */ DCR.DPNT_CVG_RQD_RLSHP_ID
, DCR.BUSINESS_GROUP_ID
, DCR.DPNT_CVG_ELIGY_PRFL_ID
, /* WHO COLUMNS */ DCR.LAST_UPDATE_DATE
, DCR.LAST_UPDATED_BY
, DCR.CREATED_BY
, DCR.CREATION_DATE
FROM BEN_DPNT_CVG_RQD_RLSHP_F DCR
WHERE DCR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, DCR.BUSINESS_GROUP_ID) WITH READ ONLY