BIP – Query to extract fast formula details

Below query will extract all the custom fast formulas along with the name of formula and formula type.

select fff.formula_name
      ,fft.formula_type_name
	  ,fff.formula_text
	  ,fff.compile_flag
	  ,fff.legislation_code
  from ff_formulas_f fff
      ,ff_formula_types fft
 where fff.formula_type_id = fft.formula_type_id 
   --and fft.formula_type_name = 'Extract Criteria'
   and fff.LAST_UPDATED_BY <> 'SEED_DATA_FROM_APPLICATION'
   AND TRUNC(SYSDATE) BETWEEN fff.effective_start_date AND fff.effective_end_date 
ORDER BY 2,1

To extract list of fast formulas used in HCM Extracts, run below query:

SELECT pedv.definition_name
      ,pedv.description
      ,pedv.legislation_code
      ,pedv.xml_tag_name
      ,pedv.ext_type_code
      ,fff.formula_name
	  ,fft.formula_type_name
  FROM pay_rep_criteria_f prcf
      ,pay_report_blocks_vl prbv
      ,per_ext_definitions_vl pedv
	  ,ff_formulas_f fff
	  ,ff_formula_types fft
 WHERE prbv.ext_definition_id = pedv.ext_definition_id
   AND prcf.report_block_id = prbv.report_block_id
   AND fff.formula_id = prcf.formula_id
   AND TRUNC(SYSDATE) BETWEEN fff.effective_start_date AND fff.effective_end_date
   AND TRUNC(SYSDATE) BETWEEN prcf.effective_start_date AND prcf.effective_end_date
   AND fff.formula_type_id = fft.formula_type_id