VIEW: APPS.BENBV_CBR_QUALD_BNF_V

Source

View Text - Preformatted

SELECT CQB.CBR_ELIG_PERD_STRT_DT, CQB.CBR_ELIG_PERD_END_DT, /* CQB.OBSOLETE, */ /* descriptive flexfield */ '_DF:BEN:BEN_CBR_QUALD_BNF_F:CQB', /* codes */ CQB.CBR_INELG_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CBR_INELG_RSN',CQB.CBR_INELG_RSN_CD), CQB.QUALD_BNF_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CQB.QUALD_BNF_FLAG), /* id columns */ CQB.CBR_QUALD_BNF_ID, CQB.QUALD_BNF_PERSON_ID, CQB.BUSINESS_GROUP_ID, CQB.CVRD_EMP_PERSON_ID, CQB.PGM_ID, CQB.PTIP_ID, CQB.PL_TYP_ID, /* who columns */ CQB.LAST_UPDATE_DATE, CQB.LAST_UPDATED_BY, CQB.CREATED_BY, CQB.CREATION_DATE FROM BEN_CBR_QUALD_BNF CQB WHERE CQB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CQB.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT CQB.CBR_ELIG_PERD_STRT_DT
, CQB.CBR_ELIG_PERD_END_DT
, /* CQB.OBSOLETE
, */ /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CBR_QUALD_BNF_F:CQB'
, /* CODES */ CQB.CBR_INELG_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CBR_INELG_RSN'
, CQB.CBR_INELG_RSN_CD)
, CQB.QUALD_BNF_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CQB.QUALD_BNF_FLAG)
, /* ID COLUMNS */ CQB.CBR_QUALD_BNF_ID
, CQB.QUALD_BNF_PERSON_ID
, CQB.BUSINESS_GROUP_ID
, CQB.CVRD_EMP_PERSON_ID
, CQB.PGM_ID
, CQB.PTIP_ID
, CQB.PL_TYP_ID
, /* WHO COLUMNS */ CQB.LAST_UPDATE_DATE
, CQB.LAST_UPDATED_BY
, CQB.CREATED_BY
, CQB.CREATION_DATE
FROM BEN_CBR_QUALD_BNF CQB
WHERE CQB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CQB.BUSINESS_GROUP_ID) WITH READ ONLY