APPS.PAY_US_ISETUP_EARN_DEDN SQL Statements

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

Line: 66

      l_ele_type_id := hr_user_init_earn.do_insertions
         (p_ele_name              => p_ele_name
         ,p_ele_reporting_name    => p_ele_reporting_name
         ,p_ele_description       => p_ele_description
         ,p_ele_classification    => p_ele_classification
         ,p_ele_category          => p_ele_category
         ,p_ele_ot_base           => p_ele_ot_base
         ,p_flsa_hours            => p_flsa_hours
         ,p_ele_processing_type   => p_ele_processing_type
         ,p_ele_priority          => p_ele_priority
         ,p_ele_standard_link     => p_ele_standard_link
         ,p_ele_calc_ff_id        => p_ele_calc_ff_id
         ,p_ele_calc_ff_name      => p_ele_calc_ff_name
         ,p_sep_check_option      => p_sep_check_option
         ,p_dedn_proc             => p_dedn_proc
         ,p_mix_flag              => p_mix_flag
         ,p_reduce_regular        => p_reduce_regular
         ,p_ele_eff_start_date    => p_ele_eff_start_date
         ,p_ele_eff_end_date      => p_ele_eff_end_date
         ,p_bg_id                 => p_bg_id
         ,p_termination_rule      => p_termination_rule
         );

Line: 197

   SELECT ff.formula_name,
          ft.formula_type_name
     FROM pay_status_processing_rules_f spr,
          ff_formulas_f ff,
          ff_formula_types ft,
          pay_element_types_f et
    WHERE et.element_type_id = p_element_type_id
      AND spr.formula_id = ff.formula_id
      AND ff.formula_type_id = ft.formula_type_id
      AND spr.element_type_id = et.element_type_id;

Line: 209

    SELECT name || ' GRP KF' grp_name
      FROM per_business_groups bg,
           pay_element_types_f et
     WHERE et.business_group_id = p_element_type_id;

Line: 224

/* update fnd_id_flex_structures
      set freeze_flex_definition_flag = 'Y'
    WHERE application_id = 801
      AND id_flex_structure_code = csr_bg_name_rec.grp_name;

Line: 241

   SELECT ff.formula_name,
          ft.formula_type_name
     FROM ff_formulas_f ff,
          ff_formula_types ft
    WHERE ff.formula_type_id = ft.formula_type_id
      AND ff.formula_id = p_formula_id;

Line: 280

  SELECT responsibility_id
    INTO l_resp_id
    FROM fnd_responsibility
   WHERE responsibility_key = 'US_HRMS_MANAGER';