View: BENBV_ELIG_CVRD_DPNT_V

Product:	BEN - Advanced Benefits
Description:	This view identifies those persons designated as dependents by a participant.
Implementation/DBA Data:	APPS.BENBV_ELIG_CVRD_DPNT_V

View Text

SELECT PDP.EFFECTIVE_START_DATE
, PDP.EFFECTIVE_END_DATE
, PDP.PROGRAM_UPDATE_DATE
, PDP.CVG_STRT_DT
, PDP.CVG_THRU_DT
, PDP.OVRDN_THRU_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_CVRD_DPNT_F:PDP'
, PDP.CVG_PNDG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDP.CVG_PNDG_FLAG)
, PDP.OVRDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDP.OVRDN_FLAG)
, /* ID COLUMNS */ PDP.ELIG_CVRD_DPNT_ID
, PDP.DPNT_PERSON_ID
, PDP.PER_IN_LER_ID
, PDP.BUSINESS_GROUP_ID
, PDP.REQUEST_ID
, PDP.PROGRAM_APPLICATION_ID
, PDP.PROGRAM_ID
, PDP.PRTT_ENRT_RSLT_ID
, PDP.ELIG_PER_ELCTBL_CHC_ID
, /* WHO COLUMNS */ PDP.LAST_UPDATE_DATE
, PDP.LAST_UPDATED_BY
, PDP.CREATED_BY
, PDP.CREATION_DATE
FROM BEN_ELIG_CVRD_DPNT_F PDP
WHERE PDP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PDP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns