VIEW: APPS.BENBV_DPNT_CVG_RQD_RLSHP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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