View: BENBV_CNTNG_PRTN_ELIG_PRFL_V

Product:	BEN - Advanced Benefits
Description:	This view identifies which continuing participation is included or excluded from an eligibility profile.
Implementation/DBA Data:	APPS.BENBV_CNTNG_PRTN_ELIG_PRFL_V

View Text

SELECT CGP.EFFECTIVE_START_DATE
, CGP.EFFECTIVE_END_DATE
, CGP.PYMT_MUST_BE_RCVD_UOM
, CGP.PYMT_MUST_BE_RCVD_NUM
, CGP.PYMT_MUST_BE_RCVD_RL
, CGP.NAME
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CNTNG_PRTN_ELIG_PRFL_F:CGP'
, /* ID COLUMNS */ CGP.CNTNG_PRTN_ELIG_PRFL_ID
, CGP.BUSINESS_GROUP_ID
, CGP.ELIGY_PRFL_ID
, /* WHO COLUMNS */ CGP.LAST_UPDATE_DATE
, CGP.LAST_UPDATED_BY
, CGP.CREATED_BY
, CGP.CREATION_DATE
FROM BEN_CNTNG_PRTN_ELIG_PRFL_F CGP
WHERE CGP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CGP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns