View: BENBV_AGE_FCTR_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BENBV_AGE_FCTR_V

View Text

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

Columns