Use this query in SQL Developer

The Two Ewes Driver enables you to run this query directly against your Oracle Fusion Applications, right from SQL Developer. Give it a try right now with a no obligation trial period.

Contributed By

Two Ewes

Send Email

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' ))