APPS.PAY_ES_BENEFIT_UPLIFT_CALC SQL Statements

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

Line: 271

  SELECT 'Y'
  FROM   ff_formulas_f ff
        ,ff_compiled_info_f ffci
  WHERE  ff.formula_id           = ffci.formula_id
  AND    ff.effective_start_date = ffci.effective_start_date
  AND    ff.effective_end_date   = ffci.effective_end_date
  AND    ff.formula_id           = p_formula_id
  AND    ff.business_group_id    = p_business_group_id
  AND    p_effective_date        BETWEEN ff.effective_start_date
                                 AND     ff.effective_end_date;

Line: 284

  SELECT ff.formula_id
  FROM   ff_formulas_f ff
  WHERE  ff.formula_name         = p_formula_name
  AND    ff.business_group_id    = p_business_group_id
  AND    p_effective_date        BETWEEN ff.effective_start_date
                                 AND     ff.effective_end_date;