VIEW: APPS.BENBV_HRS_WKD_IN_PERD_FCTR_V

Source

View Text - Preformatted

SELECT HWF.NAME, HWF.HRS_WKD_CALC_RL, HWF.HRS_WKD_DET_RL, HWF.RNDG_RL, HWF.MN_HRS_NUM, HWF.MX_HRS_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_HRS_WKD_IN_PERD_FCTR:HWF', /* codes */ HWF.PYRL_FREQ_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_FREQ',HWF.PYRL_FREQ_CD), HWF.HRS_SRC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_WKD_SRC',HWF.HRS_SRC_CD), HWF.RNDG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG',HWF.RNDG_CD), HWF.HRS_WKD_DET_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_WKD_DET',HWF.HRS_WKD_DET_CD), HWF.ONCE_R_CNTUG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONCE_R_CNTNG',HWF.ONCE_R_CNTUG_CD), HWF.HRS_WKD_BNDRY_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND',HWF.HRS_WKD_BNDRY_PERD_CD), HWF.HRS_ALT_VAL_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_ALT_VAL_TO_USE',HWF.HRS_ALT_VAL_TO_USE_CD), HWF.NO_MX_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',HWF.NO_MX_HRS_WKD_FLAG), HWF.NO_MN_HRS_WKD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',HWF.NO_MN_HRS_WKD_FLAG), /* id columns */ HWF.HRS_WKD_IN_PERD_FCTR_ID, HWF.BUSINESS_GROUP_ID, HWF.BNFTS_BAL_ID, HWF.DEFINED_BALANCE_ID, /* who columns */ HWF.LAST_UPDATE_DATE, HWF.LAST_UPDATED_BY, HWF.CREATED_BY, HWF.CREATION_DATE FROM BEN_HRS_WKD_IN_PERD_FCTR HWF WHERE HWF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, HWF.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT HWF.NAME
, HWF.HRS_WKD_CALC_RL
, HWF.HRS_WKD_DET_RL
, HWF.RNDG_RL
, HWF.MN_HRS_NUM
, HWF.MX_HRS_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_HRS_WKD_IN_PERD_FCTR:HWF'
, /* CODES */ HWF.PYRL_FREQ_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_FREQ'
, HWF.PYRL_FREQ_CD)
, HWF.HRS_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_WKD_SRC'
, HWF.HRS_SRC_CD)
, HWF.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, HWF.RNDG_CD)
, HWF.HRS_WKD_DET_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_WKD_DET'
, HWF.HRS_WKD_DET_CD)
, HWF.ONCE_R_CNTUG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONCE_R_CNTNG'
, HWF.ONCE_R_CNTUG_CD)
, HWF.HRS_WKD_BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, HWF.HRS_WKD_BNDRY_PERD_CD)
, HWF.HRS_ALT_VAL_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_ALT_VAL_TO_USE'
, HWF.HRS_ALT_VAL_TO_USE_CD)
, HWF.NO_MX_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, HWF.NO_MX_HRS_WKD_FLAG)
, HWF.NO_MN_HRS_WKD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, HWF.NO_MN_HRS_WKD_FLAG)
, /* ID COLUMNS */ HWF.HRS_WKD_IN_PERD_FCTR_ID
, HWF.BUSINESS_GROUP_ID
, HWF.BNFTS_BAL_ID
, HWF.DEFINED_BALANCE_ID
, /* WHO COLUMNS */ HWF.LAST_UPDATE_DATE
, HWF.LAST_UPDATED_BY
, HWF.CREATED_BY
, HWF.CREATION_DATE
FROM BEN_HRS_WKD_IN_PERD_FCTR HWF
WHERE HWF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, HWF.BUSINESS_GROUP_ID) WITH READ ONLY