VIEW: APPS.BENBV_LER_RLTD_PER_CS_LER_V

Source

View Text - Preformatted

SELECT LRC.EFFECTIVE_START_DATE, LRC.EFFECTIVE_END_DATE, LRC.LER_RLTD_PER_CS_CHG_RL, /* descriptive flexfield */ '_DF:BEN:BEN_LER_RLTD_PER_CS_LER_F:LRC', /* codes */ LRC.CHG_MANDATORY_CD, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',LRC.CHG_MANDATORY_CD), /* id columns */ LRC.LER_RLTD_PER_CS_LER_ID, LRC.BUSINESS_GROUP_ID, LRC.LER_ID, LRC.RLTD_PER_CHG_CS_LER_ID, /* who columns */ LRC.LAST_UPDATE_DATE, LRC.LAST_UPDATED_BY, LRC.CREATED_BY, LRC.CREATION_DATE FROM BEN_LER_RLTD_PER_CS_LER_F LRC WHERE LRC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, LRC.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT LRC.EFFECTIVE_START_DATE
, LRC.EFFECTIVE_END_DATE
, LRC.LER_RLTD_PER_CS_CHG_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_LER_RLTD_PER_CS_LER_F:LRC'
, /* CODES */ LRC.CHG_MANDATORY_CD
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LRC.CHG_MANDATORY_CD)
, /* ID COLUMNS */ LRC.LER_RLTD_PER_CS_LER_ID
, LRC.BUSINESS_GROUP_ID
, LRC.LER_ID
, LRC.RLTD_PER_CHG_CS_LER_ID
, /* WHO COLUMNS */ LRC.LAST_UPDATE_DATE
, LRC.LAST_UPDATED_BY
, LRC.CREATED_BY
, LRC.CREATION_DATE
FROM BEN_LER_RLTD_PER_CS_LER_F LRC
WHERE LRC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, LRC.BUSINESS_GROUP_ID) WITH READ ONLY