APPS.HRI_BPL_ABV SQL Statements

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

Line: 84

  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 = 'BUDGET_' || p_budget_type;

Line: 94

  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 = 'TEMPLATE_' || p_budget_type;

Line: 104

  SELECT fff.formula_id
  FROM   ff_formulas_f fff
  WHERE  fff.formula_type_id = g_formula_type_id
  AND    fff.business_group_id = 0
  AND    trunc(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
  AND    fff.formula_name = 'GLOBAL_BUDGET_' || p_budget_type;

Line: 183

  SELECT abv.value
  FROM   per_assignment_budget_values_f abv
  WHERE  abv.assignment_id = p_assignment_id
  AND    abv.unit = p_budget_type
  AND    p_effective_date BETWEEN abv.effective_start_date
                          AND abv.effective_end_date;

Line: 415

  SELECT formula_name
  FROM ff_formulas_f
  WHERE formula_id = p_formula_id;

Line: 455

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

Line: 487

  SELECT formula_id
  FROM   ff_compiled_info_f
  WHERE  formula_id = p_formula_id;

Line: 511

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

Line: 515

  SELECT formula_id INTO g_template_head_id
  FROM ff_formulas_f
  WHERE formula_type_id = g_formula_type_id
  AND formula_name = 'TEMPLATE_HEAD'
  AND business_group_id IS NULL
  AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date;