VIEW: APPS.BENBV_RLTD_PER_CHG_CS_LER_V

Source

View Text - Preformatted

SELECT RCL.EFFECTIVE_START_DATE, RCL.EFFECTIVE_END_DATE, RCL.SOURCE_COLUMN, RCL.SOURCE_TABLE, RCL.NAME, RCL.WHATIF_LBL_TXT, RCL.OLD_VAL, RCL.NEW_VAL, RCL.RLTD_PER_CHG_CS_LER_RL, /* descriptive flexfield */ '_DF:BEN:BEN_RLTD_PER_CHG_CS_LER_F:RCL', RCL.RULE_OVERRIDES_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',RCL.RULE_OVERRIDES_FLAG), /* id columns */ RCL.RLTD_PER_CHG_CS_LER_ID, RCL.BUSINESS_GROUP_ID, /* who columns */ RCL.LAST_UPDATE_DATE, RCL.LAST_UPDATED_BY, RCL.CREATED_BY, RCL.CREATION_DATE FROM BEN_RLTD_PER_CHG_CS_LER_F RCL WHERE RCL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, RCL.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT RCL.EFFECTIVE_START_DATE
, RCL.EFFECTIVE_END_DATE
, RCL.SOURCE_COLUMN
, RCL.SOURCE_TABLE
, RCL.NAME
, RCL.WHATIF_LBL_TXT
, RCL.OLD_VAL
, RCL.NEW_VAL
, RCL.RLTD_PER_CHG_CS_LER_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_RLTD_PER_CHG_CS_LER_F:RCL'
, RCL.RULE_OVERRIDES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, RCL.RULE_OVERRIDES_FLAG)
, /* ID COLUMNS */ RCL.RLTD_PER_CHG_CS_LER_ID
, RCL.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ RCL.LAST_UPDATE_DATE
, RCL.LAST_UPDATED_BY
, RCL.CREATED_BY
, RCL.CREATION_DATE
FROM BEN_RLTD_PER_CHG_CS_LER_F RCL
WHERE RCL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, RCL.BUSINESS_GROUP_ID) WITH READ ONLY