VIEW: APPS.BENBV_PL_DPNT_CVG_CTFN_V

Source

View Text - Preformatted

SELECT PND.EFFECTIVE_START_DATE, PND.EFFECTIVE_END_DATE, PND.CTFN_RQD_WHEN_RL, PND.PROGRAM_UPDATE_DATE, /* descriptive flexfield */ '_DF:BEN:BEN_PL_DPNT_CVG_CTFN_F:PND', /* codes */ PND.DPNT_CVG_CTFN_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_CTFN_TYP',PND.DPNT_CVG_CTFN_TYP_CD), PND.RLSHP_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('CONTACT',PND.RLSHP_TYP_CD), PND.PFD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PND.PFD_FLAG), PND.LACK_CTFN_SSPND_ENRT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PND.LACK_CTFN_SSPND_ENRT_FLAG), PND.RQD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PND.RQD_FLAG), /* id columns */ PND.PL_DPNT_CVG_CTFN_ID, PND.BUSINESS_GROUP_ID, PND.PL_ID, PND.REQUEST_ID, PND.PROGRAM_APPLICATION_ID, PND.PROGRAM_ID, /* who columns */ PND.LAST_UPDATE_DATE, PND.LAST_UPDATED_BY, PND.CREATED_BY, PND.CREATION_DATE FROM BEN_PL_DPNT_CVG_CTFN_F PND WHERE PND.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PND.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PND.EFFECTIVE_START_DATE
, PND.EFFECTIVE_END_DATE
, PND.CTFN_RQD_WHEN_RL
, PND.PROGRAM_UPDATE_DATE
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_DPNT_CVG_CTFN_F:PND'
, /* CODES */ PND.DPNT_CVG_CTFN_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_CTFN_TYP'
, PND.DPNT_CVG_CTFN_TYP_CD)
, PND.RLSHP_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('CONTACT'
, PND.RLSHP_TYP_CD)
, PND.PFD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PND.PFD_FLAG)
, PND.LACK_CTFN_SSPND_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PND.LACK_CTFN_SSPND_ENRT_FLAG)
, PND.RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PND.RQD_FLAG)
, /* ID COLUMNS */ PND.PL_DPNT_CVG_CTFN_ID
, PND.BUSINESS_GROUP_ID
, PND.PL_ID
, PND.REQUEST_ID
, PND.PROGRAM_APPLICATION_ID
, PND.PROGRAM_ID
, /* WHO COLUMNS */ PND.LAST_UPDATE_DATE
, PND.LAST_UPDATED_BY
, PND.CREATED_BY
, PND.CREATION_DATE
FROM BEN_PL_DPNT_CVG_CTFN_F PND
WHERE PND.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PND.BUSINESS_GROUP_ID) WITH READ ONLY