APPS.HRI_BPL_UTILIZATION SQL Statements

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

Line: 15

  SELECT formula_type_id
  FROM ff_formula_types
  WHERE formula_type_name = 'QuickPaint';

Line: 20

  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 sysdate BETWEEN fff.effective_start_date AND fff.effective_end_date
  AND fff.formula_name = 'TEMPLATE_BIS_DAYS_TO_HOURS';

Line: 35

  SELECT 'Y'
  FROM ff_formulas_f fff
  WHERE fff.formula_type_id = g_formula_type_id
  AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
  AND fff.business_group_id = p_business_group_id
  AND fff.formula_name = 'BG_ABSENCE_DURATION'
  UNION ALL
  SELECT 'Y'
  FROM
   ff_formulas_f        fff
  ,per_business_groups  bgr
  WHERE fff.formula_type_id = g_formula_type_id
  AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
  AND fff.business_group_id IS NULL
  AND bgr.business_group_id = p_business_group_id
  AND bgr.legislation_code = fff.legislation_code
  AND fff.formula_name = 'LEGISLATION_ABSENCE_DURATION'
  UNION ALL
  SELECT 'Y'
  FROM ff_formulas_f fff
  WHERE fff.formula_type_id = g_formula_type_id
  AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
  AND fff.business_group_id IS NULL
  AND fff.formula_name = 'CORE_ABSENCE_DURATION';

Line: 98

  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 = 'BIS_DAYS_TO_HOURS';

Line: 106

  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 = 'BIS_DAYS_TO_HOURS';

Line: 295

  SELECT
   piv.element_type_id
  ,bgr.legislation_code
  FROM
   per_absence_attendances       paa
  ,per_absence_attendance_types  pat
  ,pay_input_values_f            piv
  ,per_business_groups           bgr
  WHERE paa.absence_attendance_id = p_absence_attendance_id
  AND paa.business_group_id = bgr.business_group_id
  AND paa.absence_attendance_type_id = pat.absence_attendance_type_id
  AND pat.input_value_id = piv.input_value_id (+)
  AND pat.date_effective BETWEEN piv.effective_start_date (+)
                         AND piv.effective_end_date (+);