-
-

Age and Service Derived Factors

CORE HCM

Absence Types

select BCALF.name NAME_MDFAS, BCALF.cmbnd_min_val cmbnd_min_val_MDFAS, BCALF.cmbnd_max_val cmbnd_max_val_MDFAS, BAF.NAME AGE_FACTOR_MDFAS, BLF.NAME LOS_FACTOR_MDFAS from ben_cmbn_age_los_fctr BCALF , BEN_LOS_FCTR BLF ,BEN_AGE_FCTR BAF WHERE BCALF.LOS_FCTR_ID = BLF.LOS_FCTR_ID AND BCALF.AGE_FCTR_ID = BAF.AGE_FCTR_ID AND (( :P_CREATION_TYPE= 'Custom' AND BCALF.created_by <> 'SEED_DATA_FROM_APPLICATION') OR ( :P_CREATION_TYPE = 'Seeded' AND BCALF.created_by = 'SEED_DATA_FROM_APPLICATION') OR ( :P_CREATION_TYPE = 'Seeded Modified' AND BCALF.created_by = 'SEED_DATA_FROM_APPLICATION' AND BCALF.last_updated_by <> 'SEED_DATA_FROM_APPLICATION') OR (:P_CREATION_TYPE = 'ALL' ))