-
-

FTE Derived Factors

CORE HCM

FTE Derived Factors

SELECT BPFTF.NAME NAME_MDFTE, BPFTF.MN_PCT_VAL MN_PCT_VAL_MDFTE, BPFTF.MX_PCT_VAL MX_PCT_VAL_MDFTE, DECODE(BPFTF.USE_PRMRY_ASNT_ONLY_FLAG,'Y','Yes','N','No') PRMRY_ASNT_ONLY_FLAG_MDFTE, DECODE(BPFTF.USE_SUM_OF_ALL_ASNTS_FLAG,'Y','Yes','N','No') SUM_OF_ALL_ASNTS_FLAG_MDFTE, HR_GENERAL.DECODE_LOOKUP('BEN_RNDG', BPFTF.RNDG_CD) ROUNDING_RULE_MDFTE, FFFORMULAF1.BASE_FORMULA_NAME ROUNDING_FORMULA_MDFTE FROM BEN_PCT_FL_TM_FCTR BPFTF ,FF_FORMULAS_B_F FFFORMULAF1 WHERE BPFTF.RNDG_RL = FFFORMULAF1.FORMULA_ID(+) AND :P_AS_OF_DATE BETWEEN FFFORMULAF1.effective_start_date(+) AND FFFORMULAF1.effective_end_date(+) AND (( :P_CREATION_TYPE= 'Custom' AND BPFTF.created_by <> 'SEED_DATA_FROM_APPLICATION') OR ( :P_CREATION_TYPE = 'Seeded' AND BPFTF.created_by = 'SEED_DATA_FROM_APPLICATION') OR ( :P_CREATION_TYPE = 'Seeded Modified' AND BPFTF.created_by = 'SEED_DATA_FROM_APPLICATION' AND BPFTF.last_updated_by <> 'SEED_DATA_FROM_APPLICATION') OR (:P_CREATION_TYPE = 'ALL' ))