VIEW: APPS.BENBV_BNFT_RSTRN_CTFN_V

Source

View Text - Preformatted

SELECT BRC.EFFECTIVE_START_DATE, BRC.EFFECTIVE_END_DATE, BRC.CTFN_RQD_WHEN_RL, /* descriptive flexfield */ '_DF:BEN:BEN_BNFT_RSTRN_CTFN_F:BRC', /* codes */ BRC.ENRT_CTFN_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CTFN_TYP',BRC.ENRT_CTFN_TYP_CD), BRC.RQD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',BRC.RQD_FLAG), /* id columns */ BRC.BNFT_RSTRN_CTFN_ID, BRC.BUSINESS_GROUP_ID, BRC.PL_ID, /* who columns */ BRC.LAST_UPDATE_DATE, BRC.LAST_UPDATED_BY, BRC.CREATED_BY, BRC.CREATION_DATE FROM BEN_BNFT_RSTRN_CTFN_F BRC WHERE BRC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, BRC.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT BRC.EFFECTIVE_START_DATE
, BRC.EFFECTIVE_END_DATE
, BRC.CTFN_RQD_WHEN_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_BNFT_RSTRN_CTFN_F:BRC'
, /* CODES */ BRC.ENRT_CTFN_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CTFN_TYP'
, BRC.ENRT_CTFN_TYP_CD)
, BRC.RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BRC.RQD_FLAG)
, /* ID COLUMNS */ BRC.BNFT_RSTRN_CTFN_ID
, BRC.BUSINESS_GROUP_ID
, BRC.PL_ID
, /* WHO COLUMNS */ BRC.LAST_UPDATE_DATE
, BRC.LAST_UPDATED_BY
, BRC.CREATED_BY
, BRC.CREATION_DATE
FROM BEN_BNFT_RSTRN_CTFN_F BRC
WHERE BRC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BRC.BUSINESS_GROUP_ID) WITH READ ONLY