View: BENBV_SCHEDD_ENRT_RL_V

Product:	BEN - Advanced Benefits
Description:	This view specifies the rules to be enforced for a particular type of scheduled enrollment period and for a particular compensation program or plan.
Implementation/DBA Data:	APPS.BENBV_SCHEDD_ENRT_RL_V

View Text

SELECT SER.EFFECTIVE_START_DATE
, SER.EFFECTIVE_END_DATE
, SER.ORDR_TO_APLY_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_SCHEDD_ENRT_RL_F:SER'
, /* ID COLUMNS */ SER.SCHEDD_ENRT_RL_ID
, SER.BUSINESS_GROUP_ID
, SER.FORMULA_ID
, SER.ENRT_PERD_ID
, /* WHO COLUMNS */ SER.LAST_UPDATE_DATE
, SER.LAST_UPDATED_BY
, SER.CREATED_BY
, SER.CREATION_DATE
FROM BEN_SCHEDD_ENRT_RL_F SER
WHERE SER.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, SER.BUSINESS_GROUP_ID) WITH READ ONLY

Columns