View: BENBV_BENFTS_GRP_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the grouped items that can be applied to participants to enable them to be eligible for the same benefits.
Implementation/DBA Data:	APPS.BENBV_BENFTS_GRP_V

View Text

SELECT BNG.NAME
, BNG.BNG_DESC
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_BENFTS_GRP:BNG'
, /* ID COLUMNS */ BNG.BENFTS_GRP_ID
, BNG.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ BNG.LAST_UPDATE_DATE
, BNG.LAST_UPDATED_BY
, BNG.CREATED_BY
, BNG.CREATION_DATE
FROM BEN_BENFTS_GRP BNG
WHERE BNG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BNG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns