VIEW: APPS.BENBV_AGE_FCTR_V

Source

View Text - Preformatted

SELECT AGF.NAME, AGF.RNDG_RL, AGF.MX_AGE_NUM, AGF.MN_AGE_NUM, AGF.AGE_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',AGF.AGE_UOM), AGF.AGE_DET_RL, AGF.AGE_CALC_RL, /* descriptive flexfield */ '_DF:BEN:BEN_AGE_FCTR:AGF', /* codes */ AGF.RNDG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG',AGF.RNDG_CD), AGF.AGE_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_AGE_TO_USE_CD',AGF.AGE_TO_USE_CD), AGF.AGE_DET_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_AGE_DET',AGF.AGE_DET_CD), AGF.NO_MN_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',AGF.NO_MN_AGE_FLAG), AGF.NO_MX_AGE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',AGF.NO_MX_AGE_FLAG), /* id columns */ AGF.AGE_FCTR_ID, AGF.BUSINESS_GROUP_ID, /* who columns */ AGF.LAST_UPDATE_DATE, AGF.LAST_UPDATED_BY, AGF.CREATED_BY, AGF.CREATION_DATE FROM BEN_AGE_FCTR AGF WHERE AGF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, AGF.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT AGF.NAME
, AGF.RNDG_RL
, AGF.MX_AGE_NUM
, AGF.MN_AGE_NUM
, AGF.AGE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, AGF.AGE_UOM)
, AGF.AGE_DET_RL
, AGF.AGE_CALC_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_AGE_FCTR:AGF'
, /* CODES */ AGF.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, AGF.RNDG_CD)
, AGF.AGE_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_AGE_TO_USE_CD'
, AGF.AGE_TO_USE_CD)
, AGF.AGE_DET_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_AGE_DET'
, AGF.AGE_DET_CD)
, AGF.NO_MN_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, AGF.NO_MN_AGE_FLAG)
, AGF.NO_MX_AGE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, AGF.NO_MX_AGE_FLAG)
, /* ID COLUMNS */ AGF.AGE_FCTR_ID
, AGF.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ AGF.LAST_UPDATE_DATE
, AGF.LAST_UPDATED_BY
, AGF.CREATED_BY
, AGF.CREATION_DATE
FROM BEN_AGE_FCTR AGF
WHERE AGF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, AGF.BUSINESS_GROUP_ID) WITH READ ONLY