Product: | BEN - Advanced Benefits |
---|---|
Description: | This view contains information about whether a person has elected to participate in COBRA and the person's COBRA ineligibility date. |
Implementation/DBA Data: | APPS.BENBV_CBR_QUALD_BNF_V |
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