View: BENBV_CVRD_DPNT_CTFN_PRVDD_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the type of certification that was provided by a participant for a dependent covered by one of his or her benefits.
Implementation/DBA Data:	APPS.BENBV_CVRD_DPNT_CTFN_PRVDD_V

View Text

SELECT CCP.EFFECTIVE_START_DATE
, CCP.EFFECTIVE_END_DATE
, CCP.PROGRAM_UPDATE_DATE
, CCP.DPNT_DSGN_CTFN_RECD_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CVRD_DPNT_CTFN_PRVDD_F:CCP'
, /* CODES */ CCP.DPNT_DSGN_CTFN_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_CTFN_TYP'
, CCP.DPNT_DSGN_CTFN_TYP_CD)
, CCP.DPNT_DSGN_CTFN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCP.DPNT_DSGN_CTFN_RQD_FLAG)
, /* ID COLUMNS */ CCP.CVRD_DPNT_CTFN_PRVDD_ID
, CCP.BUSINESS_GROUP_ID
, CCP.ELIG_CVRD_DPNT_ID
, CCP.PRTT_ENRT_ACTN_ID
, CCP.REQUEST_ID
, CCP.PROGRAM_APPLICATION_ID
, CCP.PROGRAM_ID
, /* WHO COLUMNS */ CCP.LAST_UPDATE_DATE
, CCP.LAST_UPDATED_BY
, CCP.CREATED_BY
, CCP.CREATION_DATE
FROM BEN_CVRD_DPNT_CTFN_PRVDD_F CCP
WHERE CCP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CCP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns