APPS.HRI_OLTP_DISC_UTLZTN SQL Statements

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

Line: 81

  SELECT formula_id INTO l_formula_id
  FROM ff_formulas_f
  WHERE formula_type_id = g_formula_type_id
  AND formula_name = p_formula_name
  AND TRUNC(sysdate) BETWEEN effective_start_date AND effective_end_date
  AND (business_group_id = p_business_group_id
    OR (business_group_id IS NULL AND p_business_group_id IS NULL));

Line: 127

  SELECT formula_type_id INTO g_formula_type_id
  FROM ff_formula_types
  WHERE formula_type_name = 'QuickPaint';