APPS.PQP_CAR_CLASS_1A_PKG SQL Statements

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

Line: 31

  select element_type_id
  from pay_element_types_f
  where element_name = p_element_name;

Line: 37

  select input_value_id
  from pay_input_values_f
  where element_type_id = p_element_type_id
  and name = p_name;

Line: 132

  hr_entry_api.insert_element_entry(
           p_effective_start_date     => l_start_date,
           p_effective_end_date       => l_end_date,
           p_element_entry_id         => l_element_entry_id,
           p_assignment_id            => p_assignment_id,
           p_element_link_id          => l_element_link_id,
           p_creator_type             => 'F',
           p_entry_type               => 'E',
           p_num_entry_values         => 9,
           p_input_value_id_tbl       => inp_value_id_tbl,
           p_entry_value_tbl          => scr_valuetbl);