Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies how to calculate a person's length of service for such purposes as determining eligibility and calculating rates. |
Implementation/DBA Data: | APPS.BENBV_LOS_FCTR_V |
SELECT LSF.NAME
, LSF.LOS_DET_RL
, LSF.LOS_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, LSF.LOS_UOM)
, LSF.LOS_DT_TO_USE_RL
, LSF.RNDG_RL
, LSF.LOS_CALC_RL
, LSF.MN_LOS_NUM
, LSF.MX_LOS_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_LOS_FCTR:LSF'
, /* CODES */ LSF.LOS_DT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_LOS_DT_TO_USE'
, LSF.LOS_DT_TO_USE_CD)
, LSF.LOS_DET_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_LOS_DET'
, LSF.LOS_DET_CD)
, LSF.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, LSF.RNDG_CD)
, LSF.HRS_ALT_VAL_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRS_ALT_VAL_TO_USE'
, LSF.HRS_ALT_VAL_TO_USE_CD)
, LSF.LOS_ALT_VAL_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_LOS_ALT_VAL_TO_USE'
, LSF.LOS_ALT_VAL_TO_USE_CD)
, LSF.USE_OVERID_SVC_DT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LSF.USE_OVERID_SVC_DT_FLAG)
, LSF.NO_MX_LOS_NUM_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LSF.NO_MX_LOS_NUM_APLS_FLAG)
, LSF.NO_MN_LOS_NUM_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LSF.NO_MN_LOS_NUM_APLS_FLAG)
, /* ID COLUMNS */ LSF.LOS_FCTR_ID
, LSF.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ LSF.LAST_UPDATE_DATE
, LSF.LAST_UPDATED_BY
, LSF.CREATED_BY
, LSF.CREATION_DATE
FROM BEN_LOS_FCTR LSF
WHERE LSF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, LSF.BUSINESS_GROUP_ID) WITH READ ONLY