VIEW: APPS.BENBV_CVRD_DPNT_CTFN_PRVDD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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