APPS.HRI_BPL_FAST_FORMULA_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

  SELECT formula_type_id INTO g_formula_type_id
  FROM ff_formula_types
  WHERE formula_type_name = p_formula_type_name;

Line: 92

  SELECT fff.formula_id
  FROM ff_formulas_f fff
  WHERE fff.formula_type_id = g_formula_type_id
  AND fff.business_group_id = p_business_group_id
  AND trunc(sysdate) BETWEEN fff.effective_start_date
                     AND fff.effective_end_date
  AND fff.formula_name = p_formula_name;

Line: 101

  SELECT fff.formula_id
  FROM ff_formulas_f fff
  WHERE fff.formula_type_id = g_formula_type_id
  AND fff.business_group_id IS NULL
  AND trunc(sysdate) BETWEEN fff.effective_start_date
                     AND fff.effective_end_date
  AND fff.formula_name = p_formula_name;