[Home] [Help]
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
Name |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
ORDR_TO_APLY_NUM |
"_DF:SER" |
SCHEDD_ENRT_RL_ID |
BUSINESS_GROUP_ID |
FORMULA_ID |
ENRT_PERD_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |