VIEW: APPS.BENBV_SCHEDD_ENRT_RL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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