APPS.HRI_BPL_ASG_SUMMARIZATION SQL Statements

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

Line: 58

  SELECT fff.formula_id
  FROM
   ff_formulas_f fff
  ,ff_formula_types  fft
  WHERE fft.formula_type_name = 'QuickPaint'
  AND fff.formula_type_id = fft.formula_type_id
  AND fff.business_group_id = p_business_group_id
  AND p_date BETWEEN fff.effective_start_date AND fff.effective_end_date
  AND fff.formula_name = p_ff_name;

Line: 156

  SELECT name
  FROM   per_business_groups
  WHERE  business_group_id = p_business_group_id;