Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies how to calculate a person's hours worked in a period for such purposes as determining eligibility and calculating rates. |
Implementation/DBA Data: | APPS.BENBV_HRS_WKD_IN_PERD_FCTR_V |
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